SQL query according to culture culture

Question

Hi,

When I query the sql database, it doesn't query according to the culture differences. For an instance, if i run the following query select * from MyDB where id='Abc', I also get the record with the id Åbc. But I don't want it. I want ony the exact match. How can I sort this issue?

Thanks in advance.

Answer 1

Hi,

you can use collate in your query to enforce SQL to query based on the given collation or set it in your server.

List of Collation string<//a>

http://msdn.microsoft.com/en-us/library/ms179254.aspx

I hope this is helpful.

Elmozamil Elamir

MyBlog

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
http://elmozamil.blogspot.com