Hello.
See:
http://dev.mysql.com/doc/mysql/en/Charset.html
Andrew Mull [EMAIL PROTECTED] wrote:
That is what I was wondering, but not sure how to check/set the proper
character set.
Thanks.
-Andy
Quoting Gleb Paharenko [EMAIL PROTECTED]:
Hello.
You can write
I'm moving a database from one server to another. Both are unix based,
however the original database is on a Solaris box, and the new server is
RedHat.
The database has embedded s and 's in some of the varchar fields. When I
moved the database, I did a mysqldump, copied the text file to the
Hello.
You can write a script which will walk through all tables and
update the rows using replace() function. But, I think, you should
find the source of the problem. What odd characters have appeared after
importing? If they are just unreadable, may be the clue is in wrong character
set.
That is what I was wondering, but not sure how to check/set the proper
character set.
Thanks.
-Andy
Quoting Gleb Paharenko [EMAIL PROTECTED]:
Hello.
You can write a script which will walk through all tables and
update the rows using replace() function. But, I think, you should
find the
@lists.mysql.com
Date: Tuesday, January 04, 2005 10:19:20 AM -0500
Subject: Embedded Quotes and Special Characters.
I'm moving a database from one server to another. Both are unix
based, however the original database is on a Solaris box, and the
new server is RedHat.
The database has
, but as the representation of smart quotes isn't
standard you will.
-- Original Message --
From: Andrew Mull [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Date: Tuesday, January 04, 2005 10:19:20 AM -0500
Subject: Embedded Quotes and Special Characters.
I'm moving a database
The mySQL manual says that embedded double quotes within a single quoted
expression (as in 'OHara') need no special treatment. However, when I try
to update a data base field using such an expression, as in:
UPDATE table set col1='OHara'
the result I get is that everything to the
Please ignore earlier message -- mySQL stores embedded quotes just fine.
Wyckham Seelig
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive