COLLATE SQL_Latin1_General_CP1_CI_

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

COLLATE SQL_Latin1_General_CP1_CI_

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-22 : 09:39:08

Shyam writes "Hi,

I am a database developer. I work on SQL Server 2000. I have a table called 'Applicants'.

I want to create this table on my client machine who use SQL server 7.0.

So, i generated SQL script on my machine (SQL-2K) and ran the script on the client machine (SQl- 7.0) through SQL query Analyzer.

I get the follwing error when i run the script on the SQL 7.0 client machine.

Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near 'COLLATE'.

Sample Script:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Applicants]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Applicants]
GO

CREATE TABLE [dbo].[Applicants] (
[Applicant_id] [int] IDENTITY (1, 1) NOT NULL ,
[NameOfTheOrganization] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[TypeOfOrganization] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[OrganizationPhoneNumber] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Location] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Town] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[State] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ContactPersonFirstName] [char] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ContactPersonLastName] [char] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[ContactPersonPhoneNumber] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContactPersonEmailAddress] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Inquiry] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

When i erase the phrase 'COLLATE SQL_Latin1_General_CP1_CI_AS', and ran the script again i can generate the table successfully.

Please let me know what is wrong with the "COLLATE SQL_Latin1_General_CP1_CI_AS ".

Thanks,

Shyam."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources