Special characters handling

Hello,

We are using MySQL 5.0 series, and we would like to use special characters
in western european languages such as acute, tilde, and the like.

We are using latin1 because server configuration tool says
that's the best character set for western european languages.
First of all, is this correct?

Actually, we are having a problem in handling such characters.
After inserting such characters, it seems automatically converting
into similar alphabets like acute to "a".
Therfore, if I select the inserted data, it returns "a" instead of acute.

Is there any way to use such western european characters in MySQL?
Please let me know if you have any idea.

thanks,
Kensuke



-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]