MySQL: 4.1.11 OS: Solaris
I have a database that stores Japanese in utf-8. I have NO problems if the field is defined as VARCHAR, but if the field is defined as TEXT any data after an extended character (Japanese, special symbols etc.) gets truncated. Looking at the archives I ran the following commands:
mysql> show variables like '%char%'; +--------------------------+-----------------------------------------------+ | Variable_name | Value | +--------------------------+-----------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/local/mysql/4.1.11/share/mysql/charsets/ | +--------------------------+-----------------------------------------------+ 7 rows in set (0.00 sec)
I will spare you the details but I also checked the character set and collation for the table and the field and they were UTF-8 and utf_general_ci.
Any idea how to overcome this problem?
Thanks in advance!
DJA
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
