>> > i've still serious trouble in migrating databases createted with 4.0 to
>> > the problems is still the charset. i'm connecting to mysql with php and
>> > i try to use the 5.0 db german special chars are messed up. afaik 4.0
> > uses latin charset and 5.0 utf8 by default. can some one please give me
> > hint
> > to migrate ? i think i'm just too stupid :-)
>> Why not set your database to latin instead?
>tried this with out success - how to do it right ? reagrdless what my.cnf
>set to e.g. phpmyadmin reports to me that the db charset is UTF8. when i
>at the tables they show up as latin1 but my own php apps do not who german
>special chars as they used to ...
If the characterset for your tables is "latin", then this
should be OK.
But do you also specify the connection/client characterset?
If your server defaults to "utf8", setting it after connecting
might be required.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!