Re: Uni Code
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/27/04
- Previous message: Sue Hoegemeier: "Re: Views from Oracle using linked server"
- Maybe in reply to: Danny Chan: "Uni Code"
- Next in thread: Steve Kass: "Re: Uni Code"
- Reply: Steve Kass: "Re: Uni Code"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Apr 2004 09:53:07 +0530
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: Sue Hoegemeier: "Re: Views from Oracle using linked server"
- Maybe in reply to: Danny Chan: "Uni Code"
- Next in thread: Steve Kass: "Re: Uni Code"
- Reply: Steve Kass: "Re: Uni Code"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
