[MDEV-10206] utf8_general_ci/utf8_bin Created: 2016-06-09  Updated: 2016-06-13  Resolved: 2016-06-10

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: ManasaTulluri Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: 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

 Comments   
Comment by ManasaTulluri [ 2016-06-10 ]

Hi Any update on the above?

Comment by Sergei Golubchik [ 2016-06-10 ]

This is not a support forum, but a bug database. You can ask your questions on maria-discuss@lists.launchpad.net, #maria IRC channel on Freenode, or you can purchase MariaDB support from one of the following service providers

Generated at Thu Feb 08 07:40:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.