Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
Description
Hi ,
Sorry if the issue type is wrong. I want to do a case sensitive search on my tables so planning to re-create all the tables with UTF8_BIN.
Can you suggest which among the 2 solution's is better?
1) Re-create the table with UTF8_BIN?
2) select * from test where name collate 'utf8_bin' like 'abc';
Also can you let me know the advantages and disadvantages of using collation utf8_general_ci and utf8_bin performance wise or storage wise or any other factors