Re: Unicode characters and SQL queries

2018-02-20 Thread David Rose via 4D_Tech
ts.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-P

Re: Unicode characters and SQL queries

2018-02-19 Thread Keisuke Miyako via 4D_Tech
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

Unicode characters and SQL queries

2018-02-19 Thread David Rose via 4D_Tech
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