SQL Server Performance

Collate In Sql server

Discussion in 'T-SQL Performance Tuning for Developers' started by kmshijas, Sep 25, 2005.

  1. kmshijas New Member

    Hi<br />How i create a table in sql server with multilanguage columns .<br />ie,<br /><br />One column with arabic letters<br />One column with latin letters<br /><br />One column with french letters<br /><br />One column with greek letters<br /><br />pls give the entire table creation block.<br />the table must display all these languages fonts in the entireprise manager and query analyser<br /><br />??[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><br /><br />s K M<br />
    kmshijas, Sep 25, 2005
    #2

  2. dineshasanka Moderator

    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
    dineshasanka, Sep 25, 2005
    #2

Share This Page