Search results

Can you write down what should work ? So far nothing has worked.

Man come on. In Access DB the syntax is the normal =[name] And it works just fine. So far I did a workaround where I have added a column for entering the name in Latin, but that's not very elegant.

I just need to see all the clients with a specific name. It used to work just fine under the Access DB alone. But after the migration it doesnt. Access doesnt seem to index or see the cyrillic properly? Is there some setting that I shouldve done before the migration ?

Im just looking to see all the clients with specific name. It used to work fine when it was only on the Access DB. So I wonder if I didint prepare my DB properly for the migration. Is there any setting that I should have used?

I just saw this update. Do I have to have N'xxxx' inside all the fields with cyrillyc in it ? because I dont. The data in the fields is just plain cyrrilic with no N before it .

Here is how my query looks without any search criteria. this is how it looks when I either enter a cyrillic name , or enter the statement you gave me. this is what the desing of the query looks like with your statment and this is what the usual design of my query looks like Keep in...

Sorry about that :). I made an Access query with the statement you typed. Now it runs like before. It shows no data. @MajP I kind of get your code , but I need to do it for 30 letters and combinations and Im not sure I can figure it out , how to work after that :D

Dude did you not read my post? I tried entering this in the Access - SQL View, but it gives me syntax error. and Ideally I dont want to search just for Maria , but for whatever I type.

Hello, Ive just migrated my database to SQL. And everything seems to work just fine, but I have this problem. I live in Bulgaria, and most of my DB data is in Cyrillic. When I try to search by Customer Name in Access , I cant. When I go to SSMS , and do a query SELECT * FROM PopulationInfo...