Re: Uni Code
From: joe (pearl_77_at_hotmail.com)
Date: 04/28/04
- Next message: Keith Harris: "Table design teaser"
- Previous message: Dinesh T.K: "Re: connect to named instances"
- In reply to: Steve Kass: "Re: Uni Code"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Apr 2004 15:11:40 -0400
okay, question,
is it possible to write a condition
Where s like Japanese Characters or chinese characters?
"Steve Kass" <skass@drew.edu> wrote in message
news:u2Hj5vOLEHA.268@TK2MSFTNGP11.phx.gbl...
> 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: Keith Harris: "Table design teaser"
- Previous message: Dinesh T.K: "Re: connect to named instances"
- In reply to: Steve Kass: "Re: Uni Code"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
