Re: JDBC Encoding German
Posted by: Alexander Soklakov
Date: April 01, 2015 12:03AM

Hi Yuriy,

This is a well known issue with the comparison of such letters. The short answer is that you should use accent sensitive collation, please see the good explanation here: http://stackoverflow.com/questions/1222086/problem-with-%C3%A4-%C3%B6-%C3%A5-etc-characters-in-mysql-5

The working example:

select 'FÄ' = 'FA' COLLATE UTF8_GENERAL_CI, 'FÄ' = 'FA' COLLATE UTF8_BIN, 'FÄ' = 'FÄ' COLLATE UTF8_BIN;

returns 1, 0 and 1 respectively.


Thanks,
Alex

Options: ReplyQuote


Subject
Written By
Posted
March 10, 2015 03:26AM
Re: JDBC Encoding German
April 01, 2015 12:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.