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

Posted by Prabhakar under Sql Server on 3/23/2011 | Points: 10 | Views : 1768 | Status : [Member] [MVP] | Replies : 4
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



Responses

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

Up
0
Down

Resolved
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

Up
0
Down

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

Up
0
Down
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

Login to post response