SQL Server data Field

Hi,
  I have a nvarchar field that I need to display japanese characters in.

WHen I update with (Example - Ln¯é¹nëiUn-nv™j;JˆsB‰†)  the update runs fine but when I do a select on the field in SQL Server I just see ???????????????????????

Some help?
lrbristerAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
brejkConnect With a Mentor Commented:
When you insert data into nchar or nvarchar columns always use N prefix.

create table #temp(fld nvarchar(100))
insert into #temp
select N'Ln¯é¹nëiUn-nv™j;JˆsB'

This should allow you to store whatever you want and __IT DOES NOT DEPEND ON COLLATION__.
0
 
chapmandewCommented:
It may depend on the collation.  Are you using a japanese collation for that field?
0
 
chapmandewCommented:
Thats odd..this works fine for me:

create table #temp(fld nvarchar(100))
insert into #temp
select 'Ln¯é¹nëiUn-nv™j;JˆsB'

select * from #temp

does it for you?
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
lrbristerAuthor Commented:
chapmandew:
How do I check the collation on the field?
0
 
chapmandewCommented:
It may not...but I would think it would be fine if it is being stored in a NVARCHAR field.
0
 
lrbristerAuthor Commented:
YAY!!!  YIPPEE!!  RIGHT ON!!!!   Uh....thanks.  Great solution.  I don't care what I have to type as long as the data gets in there.
0
All Courses

From novice to tech pro — start learning today.