Re: LIKE problem with characters 'å' (norwe gian) and 'a' (mysql bug?)
> I get incorrect result when searching for the norwegian character 'å' > using LIKE. I get rows with 'a' in it, and visa versa if I search for > 'a', I get results which has 'å' in it in addition to the ones with 'a'. Make sure that your table has: charset=utf8 collation=utf8_norwegian_ci And that every column ALSO has: charset=utf8 collation=utf8_norwegian_ci Notice that I am making 'utf8_norwegian_ci' up. I looked for it using my MySQL Query Browser but couldn't find it. As I'm from Sweden I've had similar problems (åäöÅÄÖ matched åaäÅÄAÖO) and setting as above but using (the existing) 'utf8_swedish_ci' worked in my case. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql, PostgreSQL, Java
Hi, We are developing a Java EE 5 based system in which we run our system using MySQL on our local test workstation machines. Each night our project is built and deployed on our test server, which is using PostgreSQL, it's the database we will be using in our production environment as well (for reasons other than MySQL being a bad technical choice). We are wondering if the collator 'utf8_swedish_ci' is some kind of "international standard". So that you can make MySQL, PostgreSQL and Java match a string using the same criteria while still considering, for example, that Ä is the capital version of the Swedish letter ä (for case in-sensitive matching). Best regards, Kent -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]