Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> SQL Server >> Getting started with SQL Server

Turkish character "i" creates problem in my query

Dear all,

i am using SQL server for turkish language and i have a problem with turkish character "i". Whenever "i" comes in any word of query it gives wrong result. It also not able to recognize the small and capital "i" of turkish.

[276 byte] By [xishanshigri] at [2007-12-25]

«« Dataset with two tables from different sources
»» "TFS WorkItem Tracking" service does not match the trusted performance library inf

# 1

Hi,

did you already try to put a N in front of the strings, like N'SomeString' ?

That will keep track of the unicode character of strings.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

JensK.Suessmeyer at 2007-9-3 >

top of Msdn Tech,SQL Server,Getting started with SQL Server...

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified