Hi.
Look at the output of show variables like '%character_set%'; show variables like '%collat%'; show create table 'your_table'; Are all character_sets and collations the same? Keith Morris <[EMAIL PROTECTED]> wrote: > We are in the process of upgrading our installation of MySQL 4.0 to > 4.1.7 and are having an issue in our testing. > > We have an internal CMS that was developed with MySQL 4.0 and PHP. We > very often insert Text with extended characters (trademark, copyright, > registered, etc) into latin1 tables with no problem. After converting > the tables to utf8 in mysql 4.1 with "ALTER TABLE table_name > type=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin" Whenever we > try to insert Text, it will insert up to the first extended character > and then truncate the extended character to the end. It exhibits the > same behavior in CHAR, VARCHAR and TEXT fields. > > I'm sure this is a configuration problem on my part, but I have searched > google, mysql.com and the archives but have not found any information. > > If someone has any information or could point me in the right direction, > I would greatly appreciate it. > > This is running on WindowsXP with apache 2.0.52 and PHP 4.3.9. > > BTW, it is not only from PHP that this happens. It does exactly the same > thing when the query is run from MySQLCC and the MySQL Query Browser. I > have also tried pasting the text into the MySQLCC text field editor and > it appears the field will not store those characters (although I assume > that mysqlcc is just running a query in the background so it wouldn't work) > > HELP!!! Thanks in advance. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
