Re: Unicode with MySQL4.1

[Jeremy March]

You need to be sure you are using a Unicode font.  Are you using xterm?  If 
so you can go to the edit tab and click Current Profile to change the font.  
Also note that most Unicode fonts only cover subsets of Unicode not the 
whole thing so use a font that supports the language you are using.  I use 
the MiscFixed that comes with Red Hat and maybe other distributions too.

It works for me:

mysql> select convert(_ucs2 0x00d4 using utf8);
+----------------------------------+
| convert(_ucs2 0x00d4 using utf8) |
+----------------------------------+
| Ô                               |
+----------------------------------+
1 row in set (0.00 sec)
Jeremy

_________________________________________________________________
Is your computer infected with a virus?  Find out with a FREE computer virus 
scan from McAfee.  Take the FreeScan now! 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]