[For Polish mysql programmers mainly] Retrieving character ł in query
Posted by: Mikey Terracano
Date: May 14, 2015 12:34AM

I have some strings containing the polish character resembling 'l' - like the one in 'Wołoszczak'. I use utf8/utf8_general_ci (char set/collation) to store it.

Question: Is there any collation so as to be able to use plain L in a LIKE clause to succesfully retrieve strings containing this letter ?

I ask this because different flavors of a,e,i,o,u and even n with various accents, ceille etc. can be retrieved using the plain form of a,e,i,o,u and n AND utf8/utf8_general_ci (or utf8_unicode_ci).

Options: ReplyQuote


Subject
Views
Written By
Posted
[For Polish mysql programmers mainly] Retrieving character ł in query
2741
May 14, 2015 12:34AM


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.