MySQL Forums :: Character Sets, Collation, Unicode :: Vietnamese character matching with %LIKE%
Vietnamese character matching with %LIKE%
Posted by: Ryan Ward ()
Date: June 14, 2011 10:08AM
I have run into an extremely frustrating feature, for some reason a query involving select LIKE `%D%` will not match `Đ`.
All other characters that are like this do match, however. `%n%` matches `ñ`, `%o%` matches `ồ`, but if I am searching for
`%Dong Nai%` I will not get `Đồng Nai`.
Is this a MySQL feature or something hard coded into Unicode?
Edited 1 time(s). Last edit at 06/14/2011 10:15AM by Ryan Ward.
All other characters that are like this do match, however. `%n%` matches `ñ`, `%o%` matches `ồ`, but if I am searching for
`%Dong Nai%` I will not get `Đồng Nai`.
Is this a MySQL feature or something hard coded into Unicode?
Edited 1 time(s). Last edit at 06/14/2011 10:15AM by Ryan Ward.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Vietnamese character matching with %LIKE% | 2652 | Ryan Ward | 06/14/2011 10:08AM |
| Re: Vietnamese character matching with %LIKE% | 806 | Rick James | 06/15/2011 07:50PM |
| Re: Vietnamese character matching with %LIKE% | 778 | Rick James | 07/04/2011 06:53PM |
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.
© 2013, Oracle Corporation and/or its affiliates