Sql queries on unicode data [modified]
-
hi, i have created database with some fields containing nvarchar data. updated data in unicode kannda language text. I am writing queries like :- select * from table where district='UÀÄ®âUÁð'.It will not retriewing any rows. command executed success. Thanks ************ S G KORE ******************* -- Modified Saturday, September 18, 2010 3:26 AM
-
hi, i have created database with some fields containing nvarchar data. updated data in unicode kannda language text. I am writing queries like :- select * from table where district='UÀÄ®âUÁð'.It will not retriewing any rows. command executed success. Thanks ************ S G KORE ******************* -- Modified Saturday, September 18, 2010 3:26 AM
try: select * from table where district=N'UÀÄ®âUÁð' nvarchar and ntext types require the N prefix before the opening quote when you're searching for unicode text.
"An eye for an eye only ends up making the whole world blind"
-
try: select * from table where district=N'UÀÄ®âUÁð' nvarchar and ntext types require the N prefix before the opening quote when you're searching for unicode text.
"An eye for an eye only ends up making the whole world blind"
Thank you Rob Smiley. Its working ************ S G KORE *******************