[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