ajdamico at gmail.com
Fri Apr 29 08:41:53 CEST 2016
SELECT * FROM LCASE( Country ) = 'jamaica'
solve this problem?
On Fri, Apr 29, 2016 at 2:32 AM, Martin Kersten <martin at monetdb.org> wrote:
> MonetDB is case sensitive, except for those places where the SQL standard
> Strings are therefore case sensitive. There is no knob to change that
> regards, Martin
> On 28/04/16 23:19, Ariel Abadi wrote:
>> Hi All!
>> We are facing a problem, we used to work with mysql with the case
>> insensitive. Now we have moved into MonetDB and we are facing a problem
>> with this issue.
>> Some of our queries are not bringing any data because of the sensitive..
>> SELECT * FROM Country = 'jamaica' ... 0 Records
>> SELECT * FROM Country = 'Jamaica' ... 10 Records
>> Some cases we solved it using the ILIKE, but we still have some code on
>> our app that cannot be modified.
>> Does anybody know if there is any flag or setup or config for the
>> Database in Monet to make it insensitive ?
>> Thanks in advance for the help!
>> users-list mailing list
>> users-list at monetdb.org
> users-list mailing list
> users-list at monetdb.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the users-list