Hello,
I'm trying to move a database from one server to another, but I'm getting characters such as unlauts turned into question marks on the target database. Running status on both databases shows the encoding to be different:
Source:
Server characterset: latin1
Db characterset: latin1
Client characterset: binary
Conn. characterset: binary
Destination:
Server characterset: latin1
Db characterset: utf8
Client characterset: latin1
Conn. characterset: latin1
When I perform a mysqldump, the non-standard characters get converted funny:
Source DB entry:
Weg des Glücks
Dump file entry:
Weg des Glücks
Destination DB entry:
Weg des Gl?cks
So it looks like the mysqldump is going wrong?
Does anyone know how to fix this? I admit to not knowing anything about character encoding!
C:\DOS:>
C:\DOS:>RUN
RUN DOS RUN!!
I'm trying to move a database from one server to another, but I'm getting characters such as unlauts turned into question marks on the target database. Running status on both databases shows the encoding to be different:
Source:
Server characterset: latin1
Db characterset: latin1
Client characterset: binary
Conn. characterset: binary
Destination:
Server characterset: latin1
Db characterset: utf8
Client characterset: latin1
Conn. characterset: latin1
When I perform a mysqldump, the non-standard characters get converted funny:
Source DB entry:
Weg des Glücks
Dump file entry:
Weg des Glücks
Destination DB entry:
Weg des Gl?cks
So it looks like the mysqldump is going wrong?
Does anyone know how to fix this? I admit to not knowing anything about character encoding!
C:\DOS:>
C:\DOS:>RUN
RUN DOS RUN!!