Case sensitive

Anthony Damico ajdamico at gmail.com
Fri Apr 29 08:41:53 CEST 2016


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20160429/8169552b/attachment.html>


More information about the users-list mailing list