working with SQL query

Question

Summary: How to use Japanese key word in where condition. For ex:

select * from tbl_Mst_Product_Language  where Name = N'闲云舒展'

Here in above query in where condition I have used Japanese keyword which is working fine. But I want to put this value in variable as I need to pass this from c#.

Problem I am facing is where I am trying to put where conditon in variable . For example

declare @test as nvarchar(max)
set  @test = '闲云舒展'
select * from tbl_Mst_Product_Language  where Name =  @test

What seems to be the problem then? Just do that. Please explain where you are stuck, since, as it is stands now, this is not a question. — Oded
– Oded, Commented Aug 18, 2012 at 10:45
set @test = '闲云舒展' might be better as set @test = N'闲云舒展' — ta.speot.is
– ta.speot.is, Commented Aug 18, 2012 at 11:01

ta.speot.is · Accepted Answer · 2012-08-18 11:01:53Z

2

Where you have:

declare @test as nvarchar(max)
set @test = '闲云舒展'
select * from tbl_Mst_Product_Language where Name = @test

Try:

declare @test as nvarchar(max)
set @test = N'闲云舒展' -- Note here, N
select * from tbl_Mst_Product_Language where Name = @test

answered Aug 18, 2012 at 11:01

ta.speot.is

27.2k8 gold badges71 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

working with SQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related