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; If the mysql client only displays ????? it could be that the terminal you are using does not have a proper unicode font. When you type arabic into the terminal is it displayed correctly? Another thing to try if you still can't input the data properly is to input the data as hex values: INSERT INTO your_table (arabic_column) VALUES (_utf8 0xZZZZ); where ZZZZ is the utf8 hex value of the characters you want to enter. Since most people only know the ucs2 codepoint of the characters its usually easier to enter it like this: INSERT INTO your_table (arabic_column) VALUES (CONVERT(_ucs2 0xXXXX, USING utf8)); Finally just to be sure, type \s in the terminal to be sure the client and server are both using utf8. Hope this helps, Jeremy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
