> Could someone who has experience with handling the Unicode character > set in a MySQL database please write to me? In particular, I am > trying > to discover how in an ASCII-limited environment one can specify > non-ASCII characters; I do know their Unicode encodings, just not how > to write an INSERT command in SQL that uses them.
When using the mysql command line client I insert utf8 data like this: INSERT INTO your_table VALUES (CONVERT(_ucs2 0x0061 USING utf8)); if you prefer ucs2 then you don't need to convert: INSERT INTO your_table VALUES (_ucs2 0x0061); "0061" is the unicode codepoint for lowercase "a". Just replace this with the codepoint(s) of the string you want to insert. You can also, of course, insert utf8 directly: "_utf8 0x61", but who knows the utf8 codes beyond the basic latin characters?! If this doesn't fully answer your question just let me know, and I'll try to help more. Jeremy > THANKS! > > > Lisa N. Michaud, Assistant Professor of Computer Science > Department of Mathematics and Computer Science, Wheaton College > [EMAIL PROTECTED] > http://cs.wheatoncollege.edu/lmichaud -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
