Thanks Jeremy a lot, it did help.
You were right; I've been entering data correctly. I only could not see it
the right way. After a little of tests, I finally figured it out how to do
this and I'm going to tell it here so if any one had my problem, so he can
use this.
==
It sounds like you are using the mysql client to display your queries.
You should do:
SELECT HEX(arabic_column) FROM your_table;
to really see what characters are stored in the table. To see the
unicode codepoints you can do this:
SELECT HEX(CONVERT(arabic_column USING ucs2)) FROM your_table;
Hi Lorenzo,
Well I've tested all the possible ways. I even made a php file to insert
data into the data base without getting it from user (inserting a constant
string). In that file I'm sure that my string is encoded in UTF-8.
Even though I'm sure that with IE's encode set to UTF-8, it will send
> So, am I doing anything wrong or there’s a problem with MySQL itself?
I'am not sure but I had a bug like that.
You use Explore when you insert data in db?
Exlorer use UTF-16 when send data. Mozilla use UTF-8.
try change Browser.
I have solved with this line in my jsp:
request.setCharacterEncodi
Note: to see this script correctly, please set your encoding to UTF-8.
Hi
I'm trying to use the new capabilities of the MySQL 4.1.1a, which is
supporting of Unicode. I prefer to use UTF-8 instead of UCS-2 since I'm
working on web and for web UTF-8 is much more suitable.
Before asking my current
