[thelist] MSsql question

[Sean G.]

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
>