SQL Server 2008 and multi language support

hi,

i new ms sql server 2008 multiple language support. all text data type using unicode (nvarchar or ntext).
i need help and clarification. 

i can insert record sql server  e.g. insert into multi (fname) values ( n'維他命是')
however, when run select query in management studio, display boxes instead of actual text. why?? 
however, using asp.net (vb.net) applicaiton, can bind , display text in chinese in browser. also, can enter text in web application , filter chinese properly...  
que 1: however, in management studio display boxes?    suggestions?

also, record may contain simplified chinese, thai, spanish, french and other languages well... @ moment, i'm using windows xp sp3 , vs 2008 developmet..
que 2: have install languages using regional settings...

que 3: since there many languages, have set collation 1 language??
http://social.msdn.microsoft.com/forums/en-us/sqltools/thread/36f83399-88ef-459d-9514-7698b0bee584

http://msdn.microsoft.com/en-us/library/ms180175.aspx

http://msdn.microsoft.com/en-us/library/ms143508.aspx
que 4: other things when developing using vs 2008??

 please give suggestion/recommendations..

hello rama2007,

the problem is, grid view or used font of grid view of ssms don't support chinese letters.

do following: right-click query editor => resulut to => result text , execute query again.
i testet (german system & settings) , works; result show wrote (it's font "courier new")

create table #multi (fname nvarchar(30));

insert into #multi (fname) values ( n'維他命是');

 

select *

from #multi;

go

drop table #multi;

 

---

olaf helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich http://olafhelper.over-blog.de

SQL Server  >  SQL Server Tools