Prompt how it is possible to make that Access would be case sensitive in conditions of where?
By default, as I understand it, Access doesn't care about the register.
On the Internet, I found a crutch using InStr.
Is there no other way?
1 answer
You can specify the sorting type in the query using the COLLATE keyword, but the encoding must be considered.
An example can look at the English version of the site.
Community spirit ♦
one
Streletz streletz
7.391 eight 18 34
- I tried and doesn’t work or I’m doing something wrong ... As far as I understand, the question you brought me is that Access connects to MS SQL, and there it works ... - iluxa1810
- You would show what you tried. Then one could say for sure does not work or indeed something is done wrong. And, in general, how accurately the question itself describes the problem, so exactly does the answer correspond to it. No offense. If we talk about working specifically with native Access databases, Microsoft recommends working with hexadecimal character codes. Reference to the example in the following comment (it did not fit here due to length restrictions). - Streletz
- An example can be found on the official Office support site. - Streletz
|