[MonetDB-users] case insensitive
Does MonetDB has some parameter to modify the case insensitive option? when end user write sql, usually we want to case insensitive. lixiaohua Shanghai,China
On Wed, 22 Aug 2012, Stefan de Konink wrote:
On Wed, 22 Aug 2012, li, xiaohua wrote:
Does MonetDB has some parameter to modify the case insensitive option? when end user write sql, usually we want to case insensitive.
If you mean matching, you can use: columnname ILIKE "argument"
Using single quotes would help: columnname ILIKE 'argument' select kvk, bedrijfsnaam from sys.kvk where bedrijfsnaam ilike 'monetdb b.v.'; +--------------+--------------+ | kvk | bedrijfsnaam | +==============+==============+ | 321351760000 | MonetDB B.V. | +--------------+--------------+ Stefan ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ !DSPAM:1,5034904122132097614656! _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users !DSPAM:1,5034904122132097614656!
thanks for your help, ILIKE is OK when matching. but when use ='A' , ='a',
in ('a', 'A'), we don't have a good method
2012/8/22 Stefan de Konink
On Wed, 22 Aug 2012, li, xiaohua wrote:
Does MonetDB has some parameter to modify the case insensitive option?
when end user write sql, usually we want to case insensitive.
If you mean matching, you can use: columnname ILIKE "argument"
Stefan
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- 上海云数信息科技有限公司 http://www.cloudybi.com 联系人：李晓华 职务：总经理 手机：18616507502
participants (2)
-
li, xiaohua -
Stefan de Konink