Problem With German Umlauts

[uyuni]

In my table I have german Umlauts, the columns are defined as latin1.

With direct connection and with SSH everything is OK.

With http-tunnel I have problems.

When I show the table contents in the tab everything is OK.

When I copy the table to a different host or when I export to CSV the umlauts are not correct.

I have found the difference in the http-log: yogtunnel.log

show table in tab:

[default]

copy to different host/export CSV:

utf8

Why this change? Can I configure this somewhere?

My SQLYog version is 5.21.

Emile

[peterlaursen]

In utf8 non-ASCII latin characters (umlauts, nordic characters, spanish ñ etc) are encoded with two bytes.  Therefore they will not display correct – only after decoding they will.  If you open a utf8 encoded file some programs will understand – others not.  Excel for instance does not handle utf8 in CSV.

  

I do not understand every details of what you write. But please first please try upgrading to 5.29 or 6.0 beta.  There were some fixes with the tunneller and charsets handling. Quite a lot of fixes actually!

Also always tell the server version(s).   Is source 4.1 or higher (with unicode support) and target is 4.0 (without unicode support) ?

If problem persists please execute

Code:

SHOW VARIABLES LIKE '%character%';

.. on all servers involved and paste results in here.  And please give a sample CSV zip and attache here).

[uyuni]

MySQL-Version: 4.1.16

Variables:

“character_set_client”;”latin1″

“character_set_connection”;”latin1″

“character_set_database”;”latin1″

“character_set_results”;”latin1″

“character_set_server”;”latin1″

“character_set_system”;”utf8″

“character_sets_dir”;”C:\Program Files\MySQL\share\charsets/”

Variables are the same for remote and local server (except last line).

I want to do “Copy table to different host” from a tunnel-host to my localhost. This works when the tunnel is SSH but not when the tunnel is http (servers are the same for SSH/http).

Unfortunately my license expired so I cannot update SQLYog anymore.

I just downloaded the trial of 5.29 and with that version it's OK.

Emilio

[peterlaursen]

Quote:

I just downloaded the trial of 5.29 and with that version it's OK

then there realy is nothing that we can do.  Problem is fixed – what else would you expect?

[Author]

Posts