1

I have a column which has values like 'fur' and 'für'. Now if I write the query

select * from table where text = 'fur';

it gives me both 'fur' and 'für' and I want it to only return 'fur'. Which charset and collation should I use? Also when I try to use a unique index it doesn't allow me to insert 'für' as it matches with the already inserted 'fur'.

Tri
  • 11
  • 1
  • Use a `COLLATION` with a name ending in `_bin` (to compare the bits without any handling of case or accent) or containing `_as_` (for "accent sensitive"). Use `SHOW COLLATION;` to see what collations are available on the version you are using. – Rick James Aug 15 '22 at 23:17

0 Answers0