Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[beego-orm]Support Like binary #164

Closed
shenli opened this issue Sep 15, 2015 · 1 comment
Closed

[beego-orm]Support Like binary #164

shenli opened this issue Sep 15, 2015 · 1 comment

Comments

@shenli
Copy link
Member

shenli commented Sep 15, 2015

https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html#operator_like

The following two statements illustrate that string comparisons are not case sensitive unless one of the operands is a case sensitive (uses a case-sensitive collation or is a binary string):

mysql> SELECT 'abc' LIKE 'ABC';
-> 1
mysql> SELECT 'abc' LIKE _latin1 'ABC' COLLATE latin1_general_cs;
-> 0
mysql> SELECT 'abc' LIKE _latin1 'ABC' COLLATE latin1_bin;
-> 0
mysql> SELECT 'abc' LIKE BINARY 'ABC';
-> 0

@shenli shenli added the todo label Sep 15, 2015
@morgo
Copy link
Contributor

morgo commented Nov 24, 2018

The syntax described here works in TiDB with the limitation that TiDB does not yet support case-insensitive collations. Since there is an existing issue open for case sensitive collations, I am going to close this issue for now.

Please feel free to re-open if you have any followup questions. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants