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

[trq]

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.