Miyako, This worked, thanks!: SET DATABASE PARAMETER(SQL engine case sensitivity;0)
---------------------------------------------------------------------- Message: 1 Date: Mon, 19 Feb 2018 20:58:10 +0000 From: Keisuke Miyako <[email protected]> To: 4D iNug Technical <[email protected]> Subject: Re: Unicode characters and SQL queries Message-ID: <[email protected]> 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 <[email protected]> > 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:[email protected] **********************************************************************
