MySQL Forums
Forum List  »  Connector/JDBC and Java

Re: connectionCollation being igored
Posted by: Filipe Silva
Date: September 26, 2017 05:57PM

Hi Stefan,

Actually, connectionCollation is not being ignored. The issue is that it doesn't work as you expected.

Collations provided by the connection property connectionCollation end up being set in the server variable collation_connection. To better understand what this sever variable does please consult the page https://dev.mysql.com/doc/refman/5.6/en/charset-connection.html.

Summing up, the collation provided by connectionCollation affects how string literals (not column values) are compared. For example, you would get different values from the query "SELECT 'a'='A'" when setting the connection collation as "UTF8MB4_GENERAL_CI" and "UTF8MB4_BIN" through the connection property connectionCollation. Nevertheless, comparing a string literal to your table column is not affected, this is why it seems it is being ignored.

IHTH

Options: ReplyQuote


Subject
Written By
Posted
Re: connectionCollation being igored
September 26, 2017 05:57PM


Sorry, only registered users may post in this forum.

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.