;>>> 2012/03/25 23:26 +0200, Walter Tross >>>> I guess what you mean is Unicode characters U+2714 'HEAVY CHECK MARK' and U+2718 'HEAVY BALLOT X' (http://www.fileformat.info/info/unicode/char/2714/index.htm and http://www.fileformat.info/info/unicode/char/2718/index.htm). Unicode has several encodings, of which the most used are UTF-8 and UTF-16. The answer to your question depends on the encoding of your column and on your interface to the database. As an example, IF your encoding is UTF-8 and you talk to the database using PHP, you need something like: $qry = mysql_query("insert into mytable (mycolumn) values ('\xE2\x9C\x94'), ('\xE2\x9C\x98')"); Inside double quotes PHP replaces the hex escape sequences with the bytes that form the correct UTF-8 encoding of your characters (see the above web pages). <<<<<<<< Yea, even so.
But I use only MySQL client, under Vista, no PHP here. I am afraid that if I use the C-escapes to MySQL client it gives me three distinct characters, not one character that takes three bytes in UTF8. I use also Navicat, and found that I can copy the character from Word to Navicat, and Navicat well stores it in a fitting character string. But I really want it in a view, for generating input for Word (yes, I have to work MySQL CSV-ish output into real CSV, ensuring that there are no escapes in it, nor 'NULL' either). It would be splendid if there were a function that takes a U-number and turns it into a character string that safely concatenates with a field of type ...CHAR... CHARACTER SET utf8 . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
