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

Reply via email to