Re: Unicode characters and SQL queries
Miyako, This worked, thanks!: SET DATABASE PARAMETER(SQL engine case sensitivity;0) -- Message: 1 Date: Mon, 19 Feb 2018 20:58:10 + From: Keisuke Miyako <keisuke.miy...@4d.com> To: 4D iNug Technical <4d_tech@lists.4d.com> Subject: Re: Unicode characters and SQL queries Message-ID: <7d611e38-785f-4110-be05-917f41f2a...@4d.com> Content-Type: text/plain; charset="utf-8" have you tried SET DATABASE PARAMETER(SQL engine case sensitivity;0) http://doc.4d.com/4Dv16/4D/16.3/SET-DATABASE-PARAMETER.301-3651635.en.html there is also a database setting http://doc.4d.com/4Dv16/4D/16.3/SQL-page.300-3670701.en.html > On Feb 20, 2018, at 03:20, David Rose via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Any way to modify the SQL query so that it works like the 4D query without > specifying each and every specific Unicode character that I want to search > for? ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Unicode characters and SQL queries
have you tried SET DATABASE PARAMETER(SQL engine case sensitivity;0) http://doc.4d.com/4Dv16/4D/16.3/SET-DATABASE-PARAMETER.301-3651635.en.html there is also a database setting http://doc.4d.com/4Dv16/4D/16.3/SQL-page.300-3670701.en.html > On Feb 20, 2018, at 03:20, David Rose via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Any way to modify the SQL query so that it works like the 4D query without > specifying each and every specific Unicode character that I want to search > for? ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Unicode characters and SQL queries
This 4D Query will return records with Last_Name containing both "u" and "ΓΌ": QUERY([Donors];[Donors]Last_Name="@u@") This SQL query will only return records with Last_Name containing "u" Begin SQL SELECT Last_Name FROM Donors WHERE Last_Name LIKE 'u' INTO :DonorLName_at End SQL Any way to modify the SQL query so that it works like the 4D query without specifying each and every specific Unicode character that I want to search for? David ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **