RE: migrating 4.0 to 5.0

2007-03-09 Thread Little, Timothy
Here's what we did and still do : Our 4.x tables and databases were/are in Latin-1 and all the 5.x tables are/were in utf8. That means that the entire regiment of items (every column, every table, every database) in the old system (4.1) was latin-1 and all the destination items in 5.x were ent

Re: migrating 4.0 to 5.0

2007-03-05 Thread Martijn Tonies
>> > 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 s

Re: migrating 4.0 to 5.0

2007-03-05 Thread Matthias Henze
Am Montag, 5. März 2007 14:35 schrieb Martijn Tonies: > 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

Re: migrating 4.0 to 5.0

2007-03-05 Thread Martijn Tonies
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 pleas

Re: migrating 4.0 to 5.0

2007-03-05 Thread Mario Guenterberg
On Mon, Mar 05, 2007 at 08:30:13AM +0100, Matthias Henze wrote: > 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. afai