Re: Uni Code

• Previous message: addevo: "password synchronization - newbie question"
• In reply to: Hari: "Re: Uni Code"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Wed, 28 Apr 2004 02:43:21 -0400

Hari,

  I don't think it needs to be this difficult. I have no trouble at all
storing Chinese in an English SQL Server database under English Windows
with a western collation. I just use nvarchar for the columns and make
sure that the fonts for display support Chinese characters.

create table T (
s nvarchar(20)
)
insert into T values(N'中文')
go

select * from T
go

drop table T
go

Steve Kass
Drew University

Hari wrote:

>Hi,
>
>If it is SQL 2000, create a database with code page 936 (Chinese ) or in SQL
>2000 even you can create a table column collation specific.
>The create table will be some thing like below:-
>
>create table check_tab(i int, k nvarchar(20) collate Chinese_PRC_CI_AI)
>
>Note:
>
>If you use SQL Server 7.0, you should need to rebuild the master database
>to change the code page and character sets. But this will affect
>all the databases.
>
>Other easy approach:
>
>SQL Server 2000 supports the Unicode standard for character sets. No
>database settings are necessary in order to store Chinese characters.
>The front-end applications that accept and display information need to be
>configured to display the Unicode information appropriately.
>So in ur case this can be done using Chinese operating system.
>
>Thanks
>Hari
>MCDBA
>
>
>
>
>"Danny Chan" <d.chan@theone.nl> wrote in message
>news:B0AC4598-BC51-411A-BD97-75C919B94DE4@microsoft.com...
>
>
>>Dear Sirs,
>>
>>How can I save uni code (Chinese caracter) into SQL server?
>>
>>I'm looking forward to receive any help to solve this problem.
>>
>>Best Regards,
>>
>>Danny Chan
>>
>>
>>
>
>
>
>

• Previous message: addevo: "password synchronization - newbie question"
• In reply to: Hari: "Re: Uni Code"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]