From: Martijn Tonies Date: March 5 2007 1:35pm Subject: Re: migrating 4.0 to 5.0 List-Archive: http://lists.mysql.com/mysql/205402 Message-Id: <014a01c75f2b$357019c0$9902a8c0@martijnws> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, > i've still serious trouble in migrating databases createted with 4.0 to 5.0. > the problems is still the charset. i'm connecting to mysql with php and when > 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 a hint how > to migrate ? i think i'm just too stupid :-) Why not set your database to latin instead? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com