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/bugs?unsub=gcdmb-bugs@m.gmane.org

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/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Special characters handling

Hello Paul,

Thank you for the responce.
I found the discussion that I'm exactly facing with.
http://bugs.mysql.com/bug.php?id=31162

In my case, the situation was originally reported when the characters
were entered
using a web application that we are developing with Rails.
When I checked that on our linux server using SSH with Putty from my
vista machine,
I found that situation, and same situation was confirmed on my local
environment using
windows command line.

As discussed in the thread above and you mentioned, the problem is
probably caused by
the client side (Windows) and maybe some part of our application.
I will check it from different client.

Thank you for your help.

best,
Kensuke



Paul Coldrey wrote:
> 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/bugs?unsub=gcdmb-bugs@m.gmane.org