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 question, I would like to say that before this version of MySQL I was storing data in data bases encoded in UTF-8. I had no problem, all was fine, storing, retrieving and compares. The only problem (which is not a problem, but a lack) was about using FullText search on UFT-8 fields since this search takes out the unnecessary characters from the index, and most of my characters are not in the specified range (since it’s UTF-8). I hoped this was solved in the new one.
My current question:
I'm trying to insert data into a table and my data, before insertion, is encoded in UTF-8. I've created a table like this:


CREATE TABLE `articles` (
`id` INT NOT NULL AUTO_INCREMENT,
`article` TEXT CHARACTER SET utf8,
PRIMARY KEY (`id`),
FULLTEXT (`article`)
)

And then tried to insert data like this:

INSERT INTO `articles` (`id`, `article`) VALUES ('', _utf8 'مهران')

I even tried this one, which gave me the same result:

INSERT INTO `articles` (`id`, `article`) VALUES ('', CONVERT(_utf8 'مهران' USING utf8))

My string to store is an Arabic word, which in UTF-8 it takes two bytes per letter. All first bytes in each letter is 0x06 which is the ‘?’ character in ASCII. The problem is that all data stored in data base will be ‘?’. It means that only the first bytes are stored, from each character entered.
So, am I doing anything wrong or there’s a problem with MySQL itself?


[more information]
I'm using:
mysql-4.1.1a-alpha-win
php-4.3.4-Win32
windows 2000-sp4
phpMyAdmin-2.5.3-php
and IIS version 5.0

Thanks in advance,
Mehran Ziadloo

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail



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



Reply via email to