Re: migration from 4.0 to 5.0

2008-05-19 Thread Moon's Father
You are right. Mysql 4.0 don't have a concept charset. 2008/5/16 MarisRuskulis [EMAIL PROTECTED]: Found partial sollution! Need to specify mysql_query(SET NAMES 'latin1'); for connection charset. MarisRuskulis wrote: Hello! I'm trying to migrate database from mysql 4.0 to 5.0 (latin1).

migration from 4.0 to 5.0

2008-05-16 Thread MarisRuskulis
Hello! I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I maked dump from 4.0 and then restored it to 5.0, but without success because inside the web symbols isnt correct. On mysql 5.0 database charset is latin1 and SHOW TABLE STATUS shows that table is latin1. When I maked dump I

Re: migration from 4.0 to 5.0

2008-05-16 Thread MarisRuskulis
Found partial sollution! Need to specify mysql_query(SET NAMES 'latin1'); for connection charset. MarisRuskulis wrote: Hello! I'm trying to migrate database from mysql 4.0 to 5.0 (latin1). So I maked dump from 4.0 and then restored it to 5.0, but without success because inside the web symbols