Cyrillic

• Diac

  Grasshopper

  Points: 11

  More actions

  May 20, 2005 at 9:25 am

  #164405

  I'm able to put cyrillic text data in a nVarchar field but if i try to query these data no results are found... even i search the exact text of the field... no way.

  How can i make a right query?

   

  Pls help me.

  Thx advance

• May 23, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Rolandas

  SSC Enthusiast

  Points: 107

  More actions

  May 26, 2005 at 4:16 am

  #561165

  Does it work for you?

  (Substitute any Cyrillic for ????????)

  USE Northwind

  INSERT INTO Employees(LastName, FirstName) VALUES (N'Some', N'????????')

  SELECT *

  FROM Employees

  WHERE FirstName = N'????????'

   

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  May 26, 2005 at 4:27 am

  #561168

  How are you querying the data? Can you post some code?

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/