backup table issue!

[leira]

Hi,
I'm using MySQL Administrator version 1.1.3. The data in the table contains some german special characters like ä, ü etc., but when I backup the table this special characters are seted to other ascii characters like ö to ö, ü to ü and so on. What should I do so that I get the same charset? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

MA sets the wrong charset at import!

Just add this line to your file at the beginning - and it will import correctly
with 1.1.9 too (tested with MySQL 4.0 and 5.1):


SET CHARACTER_SET_RESULTS = latin1;

before

--
-- Create schema dbtest
--

and you'll 'override' what MA does wrong. I don't have MA 1.0 installed but
works with 1.1.

I also have to delete the 'TYPE = MYISAM' because MA 1.1.19 changes that to
*ENGINE ...' what MySQL 4.0 does not understand. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --