SQL Server Performance Forum – Threads Archive

Collate In Sql server

Hi How i create a table in sql server with multilanguage columns . ie, One column with arabic letters One column with latin letters One column with french letters One column with greek letters pls give the entire table creation block. the table must display all these languages fonts in the entireprise manager and query analyser ??[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] s K M

CREATE TABLE [ADS_SystemRecords] (
[SNo] [int] NOT NULL ,
[CNo] [int] NOT NULL CONSTRAINT [DF_SystemRecords_CNo] DEFAULT (0),
[SDName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Status] [char] (1) COLLATE Japanese_BIN NULL ,
[SDDesc] [varchar] (1000) COLLATE Finnish_Swedish_CS_AS NULL ,
CONSTRAINT [PK_SystemRecords] PRIMARY KEY CLUSTERED
(
[SNo],
[CNo]
) WITH FILLFACTOR = 90 ON [PRIMARY] , ) ON [PRIMARY]
GO checkhttp://www.sqlservercentral.com/columnists/dasanka/globilizationinsqlserver.asp for more information —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

]]>