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
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
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
3 matches
Mail list logo