CODEWITHSUNDEEP
mysqlunicode
bbnn
bbnn

Reputation: 3602

MySQL difficulties - Hiragana and Katakana are treated as the same

I tried to fetch ピース on mysql database SELECT * FROM edict WHERE japanese = 'ピース' However I got 3 results which are: ヒース ビーズ ピース

I tried to use ぴーす as the query and it also return the same result. SELECT * FROM edict WHERE japanese = 'ぴーす'

How can I solve this problem?

Thank you

Upvotes: 3

Views: 1687

Answers (1)

zerkms
zerkms

Reputation: 254926

I'm not sure about japanese alphabets, but you could use BINARY comparison:

WHERE BINARY japanese = 'ピース'

BINARY keyword casts string to its binary presentation, thus you have "precise" comparison.

Also, if that behaviour should be default for japanese column - you could change its collation to _bin one (it will be more efficient solution, rather than just casting)

Upvotes: 4

Related Questions