C
Charax
Using Win XP Pro SP2, Access 2003 MDB linked to SQL Server 2000.
In a query, I am unable to use Unicode characters as criteria for filtering.
The field in the underlying SQL Server 2000 table is datatype nvarchar(255), not a PK or FK. The data is mostly English ASCII but some Greek words are used. To find all records that contain the Greek letter Δ (Unicode U+0394 GREEK CAPITAL LETTER DELTA), I use this expression for criteria:
Like "*Δ*"
If this appears garbled in the newsreader, it is the letter Delta enclosed in asterisks and double-quotes.
Instead of all returning records containing letter Delta, the expression returns all records that contain a question mark character.
How can I filter using Greek Unicode characters in the criteria?
Thanks,
Charax
In a query, I am unable to use Unicode characters as criteria for filtering.
The field in the underlying SQL Server 2000 table is datatype nvarchar(255), not a PK or FK. The data is mostly English ASCII but some Greek words are used. To find all records that contain the Greek letter Δ (Unicode U+0394 GREEK CAPITAL LETTER DELTA), I use this expression for criteria:
Like "*Δ*"
If this appears garbled in the newsreader, it is the letter Delta enclosed in asterisks and double-quotes.
Instead of all returning records containing letter Delta, the expression returns all records that contain a question mark character.
How can I filter using Greek Unicode characters in the criteria?
Thanks,
Charax