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
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