Re: Uni Code
From: Steve Kass (skass_at_drew.edu)
Date: 04/28/04
- Next message: Maurice Reed: "Re: SQL 2000 after upgrade to server 2003 from NT4"
- Previous message: Don: "quotes get converted to boxes in SQL Server 2000 on 2003 Server"
- In reply to: Hari: "Re: Uni Code"
- Next in thread: joe: "Re: Uni Code"
- Reply: joe: "Re: Uni Code"
- Messages sorted by: [ date ] [ thread ]
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
>>
>>
>>
>
>
>
>
- Next message: Maurice Reed: "Re: SQL 2000 after upgrade to server 2003 from NT4"
- Previous message: Don: "quotes get converted to boxes in SQL Server 2000 on 2003 Server"
- In reply to: Hari: "Re: Uni Code"
- Next in thread: joe: "Re: Uni Code"
- Reply: joe: "Re: Uni Code"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
