Topic: Can anyone help me convert the following MSSQL Schema into MYSQL Schema?

[2levelsabove]

CREATE TABLE [ZIP] (
   [ZIP] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [STATE] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [CITY] [char] (28) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [TYP] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [FIPS] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [LAT] [float] NULL ,
   [LNG] [float] NULL ,
   [A_C] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [FINANCE] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [LL] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [FAC] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [MSA] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [PMSA] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
   [FILLER] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

[thorpe]

Better than doing it for you, I'll point you to the manual entry for CREATE TABLE thus allowing you to learn to do it yourself.

http://dev.mysql.com/doc/refman/5.0/en/create-table.html

[2levelsabove]

what about SQL_Latin1_General_CP1_CI_AS ?

I know how create works. Just wast sure on how to handle that.