Turkish character problem in select query - SQL Server

Question

SELECT [ID]
  ,[Name]
  ,[Markup]
  ,[Status] FROM [dbxyz].[dbo].[Block] WHERE Name = 'Hakkımızda'

Linq2Sql sends this query to SQL Server 2005 but because of the character problem (ı) it does not get the right dataset as a response. No rows returns.

I can not change the collation of database because it is a hosted service and I have no right to do so. I tried to change collation in column level but it did not work. What can I do?

Thanks

What is the data type for the `name` column? Hopefully something that starts with "n", like NCHAR, NVARCHAR, etc? — OMG Ponies, Oct 11 '10 at 18:25
I dunno LINQ, but `WHERE Name = N'Hakkımızda'` should work — OMG Ponies, Oct 11 '10 at 18:28
Yes, it works fine with N. But I don't know how to implement it with Linq. — xkcd, Oct 11 '10 at 18:30

score 0 · Answer 1 · answered Oct 11 '10 at 18:50

0

I think I'm gonna use ExecuteQuery. ( Bad job! :( )

http://weblogs.asp.net/scottgu/archive/2007/08/27/linq-to-sql-part-8-executing-custom-sql-expressions.aspx

answered Oct 11 '10 at 18:50

xkcd

2,538
11
59
96

score 0 · Accepted Answer · answered Oct 11 '10 at 19:32

0

Is the column Block in the database declared with the proper collation? Introduce the Turkish I issue. Note that the collation must be declared even for Unicode Nchars.

answered Oct 11 '10 at 19:32

Remus Rusanu

288,378
40
442
569

Turkish character problem in select query - SQL Server

2 Answers2