I am unable to data search by UNICODE in SQL [Resolved]

Posted by Prabhakar under Sql Server on 3/23/2011 | Points: 10 | Views : 3181 | Status : [Member] [MVP] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi firends,

i am save data in database . . my field type nvarchar.. save data like '???' . . but i am run query it's not able to catch this

by query . . any suggestion

select * from parent where name='???'

Best Regard's
Prabhakar

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Prabhakar on: 3/26/2011 [Member] [MVP] Starter | Points: 25

0	Hi firends relax it . . i do that . . solve my problem . . in case add N keyword before text name=N'???' Best Regard's Prabhakar Prabhakar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Mesh_2010 on: 3/23/2011 [Member] Starter | Points: 25

0	Hi Prabhakar you not defined values in nvarchar [code] create table parent ( name1 nvarchar(10) ) insert into parent values('???') select * from parent select * from parent where name1='???' [/code] Thanks RameSH sinGH Prabhakar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Prabhakar on: 3/26/2011 [Member] [MVP] Starter | Points: 25

0	Hi Mesh_2010 i am define value in database field with nvarchar field . Best Regard's Prabhakar Prabhakar, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts