[EMAIL PROTECTED] wrote on 19/05/2004 14:28:02:
> Hallo,
>
> I am trying to migrate a IBM-DB2 database to MySQL (4.1.1-alpha,
> Gentoo-Linux and Win32) and all is working fine, except the UTF8 tables.
>
> So I have tried a simple example
>
> create table test (
> text varchar(100) character set utf8
> ) default charset=utf8;
>
> insert into test values('ü Ã~\ ö Ã~V ä Ã~D Ã~_');
>
> This should generate "ü Ü ö Ö ä Ä ß". The upper case umlaute and s-sharp
> are not created correctely.
>
> The text of the database field is "ü � ö � ä � �"
>
> Now, what' s that????
At a guess, the problem wthe the upper case U-umlaut is that it contains
the backslash character, which is a string escape character to the
transport layer. I think you need to double it. Is the underscore also
special? Try preceding it by backslash.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]