Question about collation

Hello,

Currently in my database I have a table which contains a column with collation Turkish_CI_AI

When I try to insert a special turkish character (for instance, I -capital I with dot-) from an ASP.NET page, the character is converted to nearest match ('I') and inserted like that.

Also, I have inserted some rows containing turkish characters to the same table in my computer's SQL Server and then uploaded the table to the discountasp.net SQL Server. Turkish characters are copied but ASP.NET pages are displaying them as meaningless characters such as 'Ý' (I -capital I with dot-).

What might be the problem?

Thanks in advance

 

thanks for your answer bruce


i have found another solution and before your suggestion i tried to use that.


now, problem is solved. for entering any turkish character i am using N prefix;


insert into myTable values (N'turkishChar')