[thelist] MSsql question

Nan Harbison nansmith at heritageconcord.org
Fri Sep 5 14:07:48 CDT 2003


Thanks Sean G, Rudy, Paul and Tab,
Very helpful answers, I googled for information, but
wasn't using good search terms. I did not find and online
MS SQL book. Sean, can you send me the link to these?
TGIF!
Nan

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org]On Behalf Of Sean
G.
Sent: Thursday, September 04, 2003 9:23 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] MSsql question


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
>

--
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip
Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !





More information about the thelist mailing list