-
Collate (reply)
Not supported on sql7.
------------
strat at 6/4/2002 4:02:44 PM
Can you use "COLLATE" (see below) on SQL Server 7? I get "incorrect syntax" error?
CREATE TABLE [dbo].[CellFormat] (
[Category] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[BackColor] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FontColor] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[BackColorDesc] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FontColorDesc] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
Thanks,
strat
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|