restore my sql with tis 620

my sql dump how ca i dump mysql database but the encoding charector should be Tis620 and when I restore back the character should be tis620
teeraAsked:
Who is Participating?
 
Kim RyanConnect With a Mentor IT ConsultantCommented:
If you look at the 'create table' statements in the mysqldump file, they should define an encoding for each table.
0
 
Kim RyanIT ConsultantCommented:
What version of MySQL? The default is to dump both table definitions plus data. Within the table definition, the character encoding will be recorded, so it should just work. Have you given it a try?
0
 
teeraAuthor Commented:
MySQL 4.0.20 this is the sorce

and Server version: 4.1.20 is the destination


0
 
Kim RyanIT ConsultantCommented:
Should be fine with this version
0
 
teeraAuthor Commented:
How can I know the encoding of database in MySQL 4.0.20  be cause i can not see in
phpmyadnin like MySQL 4.1.20
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.