Re: Collate

From: Jasminder Rai <jasrai_at_canada.com>
Date: Sat, 01 Feb 2003 18:55:30 GMT
Message-ID: <CKU_9.114470$Ui4.3244028@news1.telusplanet.net>

The physical storage of character strings in Microsoft® SQL ServerT 2000 is controlled by collations. A collation specifies the bit patterns that represent each character and the rules by which characters are sorted and compared.

SQL Server 2000 supports objects that have different collations being stored in a single database. Separate SQL Server 2000 collations can be specified down to the level of columns. Each column in a table can be assigned different collations. Earlier versions of SQL Server support only one collation for each instance of SQL Server. All databases and database objects created in an instance of SQL Server 7.0 or earlier have the same collation.

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message news:tGU_9.120268$6G4.14137_at_sccrnsc02...
> What does it do?(Collate)
> Jim
> "Jasminder Rai" <jasrai_at_canada.com> wrote in message
> news:%zU_9.114461$Ui4.3243632_at_news1.telusplanet.net...
> > Like in MS-SQL Server 2000, is there an equivalent of COLLATE in Oracle
> >
> > Thank you,
> >
> > Jasminder
> >
> >
>
>
Received on Sat Feb 01 2003 - 12:55:30 CST