… been utf-8, the tables were MyISAM – it came out of Sql Server into MySQL, and may have been converted to utf-8 during… (addition of Capital A with Circumflex). On a web page (utf-8 in header and content-type meta tag), it is as… page showing it is in utf-8 or ISO-8859-1), though if I display it converted to utf-8, it’s back to…

… set the encoding, some of the rows were actually in UTF-8. That needed to be fixed. Simply using CONVERT(column USING… 2nd conversion the result is in UTF-8, and this time MySQL knows that it’s UTF-8 as well. So it will perform… encoding issues in Russian, and other national SBCS encoding vs UTF-8 issues, I suppose. But, of course, ideally you’d always…

Jeroen, this means that the data you’re marking as UTF-8 is *not* really in UTF-8 encoding, and then UTF-8 decoder chokes. Eg. if the binary data is actually is in Latin-1 encoding but you’re tricking MySQL to think it’s in UTF-8, the decoder will choke at the very first non-ASCII7 symbol.

… strings fields actually contain valid UTF-8. Is there a way to convert the table definition to utf-8 without it trying to transcode the strings, which are already in the correct encoding? Converting the utf-8 to latin1… 1-byte character sets – I need to maintain the full utf-8 character set during the change. Is there a away to…

… their first language. I have changed all my fields to UTF-8, so that I can simply store anything anywhere Chinese. however… point me if I am wrong. 1.> keep everything as UTF-8, collation UTF9_general_ci 2.> keep all English columns as… collation as latin1_swedish_ci and chinese colums as as UTF-8, collation UTF9_general_ci Database is stored on local server…

… ALTER the existing table and set UTF-8 on a column. The data would then get UTF-8 encoded twice. So you’d need… convert the column to binary character set and then to UTF-8 again; see below.

… bit for converting a database characterset latin_1 to an utf_8 characterset. (Just like SCC above.) But I have a problem… in the database. But when I convert the database into utf_8 all contents of the fields containing these symbols are droppen…