[thelist] MSsql question
Sean G.
ethanol at mathlab.sunysb.edu
Thu Sep 4 20:23:29 CDT 2003
Howdy,
Yup. This creates the table assistance owned by jfy_user in the current
database.
COLLATE identifies the alphabet or language for the characters in the varchar
objects and how they should be sorted.
>From the MS-SQL books on line:
"A collation encodes the rules governing the proper use of characters for
either a language, such as Macedonian or Polish, or an alphabet, such as
Latin1_General (the Latin alphabet used by western European languages).
Each SQL Server collation specifies three properties:
The sort order to use for Unicode data types (nchar, nvarchar, and ntext). A
sort order defines the sequence in which characters are sorted, and the way
characters are evaluated in comparison operations.
The sort order to use for non-Unicode character data types (char, varchar, and
text).
The code page used to store non-Unicode character data."
HTH,
Sean G.
"No matter how much money Bruce [Springsteen] gives to charity, I still say
he's one of the tightest men I've ever known." - David Sedaris.
>-----Original Message-----
>
>CREATE TABLE [jfy_user].[assistance] (
> [assistance_id] [int] IDENTITY (1, 1) NOT NULL ,
> [assistance] [varchar] (15) COLLATE
>SQL_Latin1_General_CP1_CI_AS NULL
>) ON [PRIMARY]
>GO
>
More information about the thelist
mailing list