Anderson, David B
david.b.anderson at citi.com
Sat Apr 30 17:17:34 CEST 2016
It's ugly, but if you compile from source, you could change the C-code to use case insensitive comparisons. Not sure if the same code is used by MonetDB itself to lookup tables etc.
From: Alberto Ferrari [aferrari at starconnecting.com<mailto:aferrari at starconnecting.com>]
Sent: Saturday, April 30, 2016 08:38 AM Eastern Standard Time
To: Communication channel for MonetDB users
Subject: Re: Case sensitive
Anthony, as Ariel said, in some cases we cannot modify the query.
Email/Hangout: aferrari at starconnecting.com
2016-04-29 3:41 GMT-03:00 Anthony Damico <ajdamico at gmail.com>:
> hi, would
> 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
> 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