|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
11/09/2008, 23h23
|
#1 |
Messages: n/a
Hébergeur: |
Store Unicode characters
Hello,
I am trying to store Unicode characters (i.e. - Chinese, Polish, French, English, ... ) in my database tables. Sample Table: ---------------- Create Table myTest ( somevalue NVarchar(50) ) Sample Insert: ----------------- Insert into mytest values (N'基本上') Insert into mytest values(N'some value') When I execute the above sql select statement the chinese characters are NOT inserted correctly What's the problem?? Thanks Asier |
|
|
11/09/2008, 23h35
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Store Unicode characters
What do you mean they are not inserted correctly? If I just copy and
paste your sample in SSMS it inserts correctly both rows (SQL Server 2008). -- Plamen Ratchev http://www.SQLStudio.com |
|
|
|
11/09/2008, 23h39
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: Store Unicode characters
Hi
I use Sqlserver2005. I can not see characters. I see squares Thanks "Plamen Ratchev" <Plamen@SQLStudio.com> escribió en el mensaje de noticias news:6_ednUTQNo6lElTVnZ2dnUVZ_gGdnZ2d@speakeasy.ne t... > What do you mean they are not inserted correctly? If I just copy and paste > your sample in SSMS it inserts correctly both rows (SQL Server 2008). > > -- > Plamen Ratchev > http://www.SQLStudio.com |
|
|
|
12/09/2008, 00h54
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: Store Unicode characters
It works fine on SQL Server 2005 too. Do you have Chinese fonts
installed in Windows? Also, make sure the Query Editor font (under Tools -> Options -> Environment -> Fonts and Colors) is set to font that supports Unicode characters. -- Plamen Ratchev http://www.SQLStudio.com |
|
|
 |
| Outils de la discussion | |
|
|
