Hello.
As said at: http://dev.mysql.com/doc/mysql/en/charset-conversion.html You should avoid trying to convert directly from latin1 to the real character set. If you have a backup, import a table from it. Check that your character_set_xxx variables have a corresponding values. See: http://dev.mysql.com/doc/mysql/en/charset-defaults.html Eli <[EMAIL PROTECTED]> wrote: > Hi.. > > I encountered some problems with character sets. > > On the 4.0 version I stored UTF-8 strings. When upgraded to 4.1, I saw > the default character set was 'latin1', so I converted to UTF-8 using this: > > ALTER TABLE my_table CONVERT TO CHARACTER SET 'utf8', DEFAULT CHARACTER > SET 'utf8'; > > When viewing the pages, I see that some of the characters were corrupted > (the same chars always). I tried to return to convert back to 'latin1' > but the problem remained. > > What was the problem? > How can I fix it? > > BTW: for some reason I cannot reply to posts in this mailing list using > Thunderbird. (On PHP mailing list replying works). > > please help... > -thanks, Eli > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
