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?
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?
chapmandew
It may depend on the collation. Are you using a japanese collation for that field?
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?
create table #temp(fld nvarchar(100))
insert into #temp
select 'Ln¯é¹nëiUn-nv™j ;JˆsB'
select * from #temp
does it for you?
ASKER
chapmandew:
How do I check the collation on the field?
How do I check the collation on the field?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It may not...but I would think it would be fine if it is being stored in a NVARCHAR field.
ASKER
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.