JDBC Encoding German
Posted by: Yuriy Dzhenyeyev
Date: March 10, 2015 03:26AM

Hello everyone,

I am using MySQL 5.6.20 with ConnectorJ 5.1.31.

Connection String: jdbc:mysql://localhost:3306/[database name]

The query

select 'FÄ' = 'FA', 'FA' = 'FA';

returns 0 und 1.

The query

select * from [table name] where old_value = 'FA';

returns a row with old_value = 'FÄ'.

The table's and server's character set is utf8.

The same query executed in MySQL Workbench returns 1 for 'FÄ' = 'FA'.

How should I configure the driver / the server to have 'FÄ' <> 'FA'?

Options: ReplyQuote

Written By
JDBC Encoding German
March 10, 2015 03:26AM

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.