Javi

[javier gonzalez]

hi , I have installed mysql 4.1.4 because I wanted to try the unicode support utf8 , now I Explain what I dont understand,
so I declare a database that has the character set utf 8, and inside that database I create a table that has also the character set utf8, ok, now I create a simple script to enter something in a form that is stored in that table, the html page is in utf-8 also, I type something with a unicode editor in arabic and I enter it, and to my surprise when I go to look at the database I find something similar to this : بيسبسيبتصثقتنصثقصثبيسبسيبتصث&#16

which is what typically I would get if I didnt have unicode support in mysql, so what am I doing wrong?

same thing happens if I just try to enter directly into the database using a client, without using php, say that I load DBManager professional, and I go to that table I created which has the character set UTF-8, so directly I try to enter something in unicode taken from my unicode editor which is SC Unipad , and again it enters it and then instead of viewing the characters in arabic or thai or whatever I entered again I see the lines of 1579;بيسبسيبتصث&#16 etc etc

so what am I doing wrong, I thought the point of declaring a table and database as character set utf 8 is that I would use my mysql client to view the database and I would see the fields in the original characters of the different languages, so obviously Im doing something wrong,

I will appreciate very much any help
thank u
my email is [e-mail]

best

Javi
:)