> Entering it in hex works for me too. So the problem _was_ actually with > the values I inserted into the database. > > What's the best way to actually see what is stored in the database, > preferably as hex or something else that a terminal is guaranteed to > display correctly? Clearly, what I was doing earlier was not correct.
SELECT hex(your_column) FROM your_table; I usually convert utf8 to ucs2 so that I can recognize the codepoints easier. SELECT hex(CONVERT(your_column USING ucs2)) FROM your_table; There is also a new UNHEX() function which appeared in 4.1.2. best, Jeremy March -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
