Hi,
I have installed XFree86 4.3 and started xterm with
xterm -fn
-Misc-Fixed-Medium-R-SemiCondensed--13-120-75-75-C-60-ISO10646-1
Then started mysql with
mysql --default-character-set=utf8
Set LC_CTYPE to en_US.UTF-8 on my SuSE 8 machine.
Still I am not able to display Unicode characters.
I
It seems to be working, but I am facing a glitch with
display.
I tried
select convert(_ucs2 0x0400 using utf8);
+--+
| convert(_ucs2 0x0400 using utf8) |
+--+
| ?|
+--+
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
Oops--the Unicode character must have gotten lost in the email, but it does
show up in MySQL. Its an O with a line above it.
_
MSN Messenger with backgrounds, emoticons and more.
Hi,
I am trying to insert unicode characters in to a table
from mysql client, but I am unable to.
My configuration is
MySQL4.1.0-alpha on SunOS8. Installed MySQL from
source with support for all character sets.
Created table with create table mm(xyz varchar(10)
character set utf8), and started
Remember that utf8 is not the same as the Unicode codepoints. If you want
to enter utf8 like that you need to convert it from ucs2 first. Try this:
SELECT convert(_ucs2 0x00d4 using utf8);
and to insert:
INSERT INTO your_table values (convert(_ucs2 0x00d4 using utf8));
You can compare the
