Databases
StackOverflow2013
Postsdbo
POHow to get MySQL to match `%D%` => `Đ`
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to get MySQL to match `%D%` => `Đ`
    primarykey
    data
    text
    <p>I have run into an extremely frustrating feature, for some reason a query involving select <code>LIKE %D%</code> will not match <code>Đ</code>.</p> <p>All other characters that are like this do match, however. <code>%n%</code> matches <code>ñ</code>, <code>%o%</code> matches <code>ồ</code>, but if I am searching for <code>%Dong Nai%</code> I will not get <code>Đồng Nai</code>.</p> <p>Although <code>%Thua Thien-Hue%</code> will match <code>Thừa Thiên-Huế</code></p> <p>Is this a MySQL feature or something hard coded into Unicode, or is there a way around this? It makes people who are using my website unable to find events about certain Vietnamese provinces, unless they have access to the <code>Đ</code> key, which virtually nobody in America does.</p> <p>EDIT:</p> <p>The fact that a, e, i, o, or u matches all Vietnamese vowels is very unexpected behavior to a Vietnamese speaker.</p> <p>For reference; here are all the Vowels in Vietnamese.</p> <p>à, á, ã̉, ạ, a, ằ, ắ, ẵ, ẳ, ặ, ă, ầ, ấ, ẫ, ẩ, ậ, â, è, é, ẽ, ẻ, ẹ, e, ề, ế, ễ, ể, ệ, ê, ì, í, ĩ, ỉ, ị, i, ò, ó, õ, ỏ ,ọ, o, ồ, ố ,ỗ, ổ, ộ ,ô, ờ, ớ ,ỡ, ở, ợ, ơ, ù, ú, ũ, ủ, ụ, u, ừ, ứ , ữ , ử, ự, ư</p> <hr> <p>My question is then, 'What constitutes a different enough letter?'.</p> <hr> <p><strong>It appears other Vietnamese speakers have reported this as a bug to MySQL:</strong></p> <p>This behavior appears to not be present in 5.6+. I will let you know if an update of MySQL helps.</p> <p><a href="http://bugs.mysql.com/bug.php?id=61258" rel="nofollow">http://bugs.mysql.com/bug.php?id=61258</a></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCayetano Gonçalves
    1. USCayetano Gonçalves
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to get MySQL to match `%D%` => `Đ`
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONot sure if there is a solution... but in case you don't find anything better you could always use a `REPLACE` statement. Something like `SELECT field FROM column WHERE REPLACE(column, 'Đ', 'D') LIKE ("%D%")`
      singulars
      1. POHow to get MySQL to match `%D%` => `Đ`
      1. USnico
    2. COThat's a possibility. Seems messy though
      singulars
      1. POHow to get MySQL to match `%D%` => `Đ`
      1. USCayetano Gonçalves
    3. COYou need to adjust the collation that's being used so MySQL knows that it needs to match `D` and `Đ`. Googling and reading at MySQL site will tell you how to do that (it's not easy but not overly complex).
      singulars
      1. POHow to get MySQL to match `%D%` => `Đ`
      1. USN.B.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload