MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Special characters handling          MySQLTalk.org Forum Index -> MySQL Bugs View previous topic :: View next topic   Author Message Kensuke Ohta Guest Posted: Sat Jul 12, 2008 7:46 am    Post subject: 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 Back to top Paul Coldrey Guest Posted: Sat Jul 12, 2008 10:55 am    Post subject: 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: Quote: 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 Back to top Kensuke Ohta Guest Posted: Sun Jul 13, 2008 4:36 am    Post subject: 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: Quote: 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 Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> MySQL Bugs All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.