Case sensitive

Martin Kersten martin at monetdb.org
Fri Apr 29 08:32:51 CEST 2016


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
>



More information about the users-list mailing list