2levelsabove Posted February 6, 2010 Share Posted February 6, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/191156-can-anyone-help-me-convert-the-following-mssql-schema-into-mysql-schema/ Share on other sites More sharing options...
trq Posted February 7, 2010 Share Posted February 7, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/191156-can-anyone-help-me-convert-the-following-mssql-schema-into-mysql-schema/#findComment-1008184 Share on other sites More sharing options...
2levelsabove Posted February 7, 2010 Author Share Posted February 7, 2010 what about SQL_Latin1_General_CP1_CI_AS ? I know how create works. Just wast sure on how to handle that. Quote Link to comment https://forums.phpfreaks.com/topic/191156-can-anyone-help-me-convert-the-following-mssql-schema-into-mysql-schema/#findComment-1008235 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.