CODEWITHSUNDEEP
ms-accessunicodespecial-characters
user9
user9

Reputation: 145

Microsoft Access query search for words with special character

I have a table in Microsoft Access with words that contain Romanian characters. I want to query for words that contain ț (Latin small letter T with cedilla).

The following query gives back all the entries of my table "words", just as if it was another wildcard:

 "SELECT words.[word]
    FROM words
    WHERE (((words.[word]) Like "*ț*"));

Any idea how to search for words that contain that character?

By the way, if I search for words with "ă" (Latin small letter a with breve) it works as expected.

Upvotes: 1

Views: 1092

Answers (1)

Jörgen R
Jörgen R

Reputation: 386

The reason seems to be that "Like" uses ascii and interprets every character it can't understand as a question mark. Try this instead:

SELECT words.[word]
    FROM words
    WHERE instr(words.[word],"ț")>0

Upvotes: 2

Related Questions