U++ forum: Welcome to the forum

Re: How to use Like() with SqlArray [message #4132 is a reply to message #4131]

Mon, 24 July 2006 09:49

unodgs
Messages: 1367
Registered: November 2005
Location: Poland

Ultimate Contributor

zsolt wrote on Mon, 24 July 2006 02:59

Thanks, you are right.
I have changed Like() in Sqlexp.cpp from

SqlBool Like(const SqlVal& a, const SqlVal& b) {
	int sqld = GetSqlDialect(a, b);
	return SqlBool(a, sqld == SQLD_MYSQL || sqld == SQLD_SQLITE3 ? " like binary " : " like ", b, SqlS::COMP);
}

SqlBool Like(const SqlVal& a, const SqlVal& b) {
	int sqld = GetSqlDialect(a, b);
	return SqlBool(a, sqld == SQLD_MYSQL ? " like binary " : " like ", b, SqlS::COMP);
}

and now it is working correcly. I have no idea why that "binary" was in sources. I tested "like binary" directly in sqlite and it produces an error. So this was a bug, I think.

From mysql page:

The following two statements illustrate that string comparisons are not case sensitive unless one of the operands is a binary string:
mysql> SELECT 'abc' LIKE 'ABC';
-> 1
mysql> SELECT 'abc' LIKE BINARY 'ABC';
-> 0

http://dev.mysql.com/doc/refman/5.0/en/string-comparison-fun ctions.html

More about binary operator:
http://dev.mysql.com/doc/refman/5.1/en/charset-binary-op.htm l

Report message to a moderator