[yunqa.de] Re: How do I perform an accent insensitive compare
- From: Armitage profile <armitage49@xxxxxxxxx>
- To: "yunqa@xxxxxxxxxxxxx" <yunqa@xxxxxxxxxxxxx>
- Date: Wed, 24 Oct 2012 00:07:00 -0700 (PDT)
If you use PoastgresSQL you want to use "select * from pg_collation" to view
all collation is instaled in you database.
Best regards ,
Adrian POPA
________________________________
From: Yannick SILVA <yannick.silva@xxxxxxxxx>
To: yunqa@xxxxxxxxxxxxx
Sent: Wednesday, October 24, 2012 9:36 AM
Subject: [yunqa.de] How do I perform an accent insensitive compare
Dears,
I try to use the collate SQL_Latin1_General_CP1_CI_AI to make a accent
insensitive compare but it failed with exception class ESQLite3 Error 1 - no
such collation sequence : SQL_Latin1_General_CP1_CI_AI
I took the reference on this web site :
http://stackoverflow.com/questions/2461522/how-do-i-perform-an-accent-insensitive-compare-e-with-e-e-e-and-e-in-sql-ser
Anyone knows how to solve this or to adapt it for Delphi/Disqlite3 ?
Here is the kind of query I do :
SELECT * FROM myTable WHERE name LIKE "%cafe%" COLLATE
SQL_Latin1_General_CP1_CI_AI
Thanks.
Best regards,
Yannick SILVA.
Other related posts:
