> now the really interesting part is: all other (or at least > a lot of other) accented european characters are being > displayed correctly _only_ german umlauts are allways shown > as question marks. > > does anybody care to explain and give me a hint on what > to do. i am completely confused. >
The first thing you should do is query your database to determine what actual hex value mysql is storing for the umlaut. SELECT HEX(CONVERT(german_col USING ucs2)) FROM your_table; This will show you the unicode code points for the data in german_col. I don't know off hand which unicode code points represent the German umlauts, but if you don't know you can look them up on unicode.org. If the code point being stored is the correct one for a German umlaut then you are having a display problem. This is probably due to an improper font, or the client or server not using the correct encoding. Don't forget "SET CHARACTER SET utf8;" on your client! If the the hex values you find in place of the umlaut are not correct then somehow your data is being corrupted/translated before it is loaded/inserted. Try inserting the hex value directly and see if MySQL stores this properly. INSERT INTO your_table VALUES (CONVERT(_ucs2 0xYYYY USING utf8)); where YYYY is the code point for the umlaut character. Hopefully this query will show the correct code point next to a correctly displayed umlaut character: SELECT HEX(CONVERT(german_col USING ucs2)), german_col FROM your_table; Good luck, Jeremy March -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
