Home » U++ Library support » U++ SQL » How to use Like() with SqlArray
| Re: How to use Like() with SqlArray [message #4131 is a reply to message #4129] |
Mon, 24 July 2006 08:59   |
zsolt
Messages: 702
Registered: December 2005
Location: Budapest, Hungary
|
Contributor |
|
|
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);
}
to
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.
|
|
|
|
Current Time: Tue Aug 12 07:12:26 CEST 2025
Total time taken to generate the page: 0.06062 seconds
|
Members
Pages
Help
Register
Login
Home
