hi,
i am trying to get german umlauts into my database. shouldnt be that hard...
i am working on a linux machine with the following settings
suse 9.0 MySQL-server-4.1.1-1 MySQL-client-4.1.1-0
#> locale LANG=de_DE.UTF-8 LC_CTYPE="de_DE.UTF-8" LC_NUMERIC="de_DE.UTF-8" LC_TIME="de_DE.UTF-8" LC_COLLATE="de_DE.UTF-8" LC_MONETARY="de_DE.UTF-8" LC_MESSAGES="de_DE.UTF-8" LC_PAPER="de_DE.UTF-8" LC_NAME="de_DE.UTF-8" LC_ADDRESS="de_DE.UTF-8" LC_TELEPHONE="de_DE.UTF-8" LC_MEASUREMENT="de_DE.UTF-8" LC_IDENTIFICATION="de_DE.UTF-8" LC_ALL=
mysql> SHOW VARIABLES LIKE 'character%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_server | utf8 | | character_set_system | utf8 | | character_set_database | utf8 | | character_set_client | utf8 | | character_set_connection | utf8 | | character-sets-dir | /usr/share/mysql/charsets/ | | character_set_results | utf8 | +--------------------------+----------------------------+
sofar so good. seems to be almost ok. now comes the tricky part. as our location is in germany we want to be able to support german umlauts but as we are also multinational we want to support at least all of europe.
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.
thank you very much
ciao robertj
smime.p7s
Description: S/MIME Cryptographic Signature
