Case sensitive

Alberto Ferrari aferrari at starconnecting.com
Sat Apr 30 14:31:54 CEST 2016


Anthony, as Ariel said, in some cases we cannot modify the query.


Alberto Ferrari
Email/Hangout: aferrari at starconnecting.com
Skype: support-starconnecting



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:
>>
>> Hi
>>
>> MonetDB is case sensitive, except for those places where the SQL standard
>> allows.
>> Strings are therefore case sensitive. There is no knob to change that
>> behavior.
>>
>> 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
>>> https://www.monetdb.org/mailman/listinfo/users-list
>>>
>>
>> _______________________________________________
>> users-list mailing list
>> users-list at monetdb.org
>> https://www.monetdb.org/mailman/listinfo/users-list
>
>
>
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>


More information about the users-list mailing list