You are right.
Mysql 4.0 don't have a concept charset.

2008/5/16 MarisRuskulis <maris@co.inbox.lv>:

> 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 isnt correct. On mysql 5.0 database
> charset is latin1 and "SHOW TABLE STATUS" shows that table is latin1.
> When I maked dump I passed --default-character-set=latin1 option, but
> without success. I even tryed to copy data files to 5.0 and the result
> is same.
> hope that someone will help me.
>
>
>
> ------------------------------
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=y...0608@gmail.com
>



--
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn