Hi All
I am very confused about MySQL 4.1.3. I have problems with the character set
and the collation. Under 4.0.20 I had never such problems.
I downloaded the beta-files from version 4.1.3b and zipped it to c:\mysql.
Then I loaded my data within a script with "load data infile" into my
tables... The point is, that all tables have now the collation
'latin1_swedish_ci'?!!? Is this the default collation? Why does this
collation appear? Interesting is, that the meta-data (all tables in the
mysql-db) does have the 'latin1_swedish_ci' - collation too.
The problem is now with phpmyadmin, if I make a select like
"SUBSTRING_INDEX( domain, '.', -2 ) from url_cat", the following
error-message appears: Error #1267 - Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE). I found out,
that if I use the following statement "select SUBSTRING_INDEX( domain,
_latin1'.', -2 ) from url_cat" it works!!!! But the Problem is, i won't
change all my old scripts from 4.0!!! I found out, that if I use mysql in
DOS, everything works without error!!! Do I have to change something in
phpmyadmin (i have version 2.6.0rc1)?
I am very confused about it and i don't know how and which character-set and
collation I have to choose. I live in Switzerland... Which character-set and
collation I have to choose? Is there a 'standard' character-set/collation I
should use? Do I have to set parameters in the my.cnf - file?
My system runs under Windows XP with SP2.
Thank you in advance for your help.
Yours
Martin Rytz
DBA from Switzerland
