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

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