Re: Special characters handling

Hi Kensuke,

For future reference this probably belonged on the users list rather 
than the bugs list. Having said that latin1 should support all the 
accented characters for the western European languages (see 
http://casa.colorado.edu/~ajsh/iso8859-1.html for a list). If you are 
planning to support Czech (which has some of it's own special 
characters) then you'll probably want to use UTF-8.  If you accented a's 
are being modified then it might be your client app rather than the 
database that is messing this up (particularly if you are using Windows).

Cheers,

    Paul.

Kensuke Ohta wrote:
> 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]