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] **********************************************************************
