Re: Mysql 4.1.7 Text truncates at first extended character on insert

2004-11-04 Thread Gleb Paharenko
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 MySQ

Mysql 4.1.7 Text truncates at first extended character on insert

2004-11-03 Thread Keith Morris
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