Dear Falcon, > I am trying to migrate a few MS SQL databases > to mySQL and I need to know what the equivalent mysql > datatypes are for the following MS SQL datatypes:
I am not too familiar with MS SQL, so someone please correct me if I'm wrong with this list: > nvarchar -> [NATIONAL] VARCHAR > smallint -> SMALLINT > bit -> CHAR(0) > int -> INT > ntext -> TEXT (if you experience charset problems, BLOB may be better) > real -> DOUBLE > datetime -> DATETIME > float -> FLOAT > money -> DECIMAL (closest) > smalldatetime -> DATETIME > numeric -> DECIMAL (or NUMERIC, which is a synonym for DECIMAL in MySQL) > decimal -> DECIMAL You can configure the charset used with the server and with the client. With the server, you can use --charset=... when starting the server, or in the my.cnf/my.ini configuration file. Up to now, MySQL will only use _one_ configured (server) charset, but this is on the TODO list and is very likely to change in the near future (when you can configure/use multiple charsets). Regards, -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "blind falcon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 11, 2002 9:59 PM Subject: porting M$ SQL to mySQL > Okay, I must admit that I am a complete newbie to > mySQL but I was wondering if someone could please help > me out. I am trying to migrate a few MS SQL databases > to mySQL and I need to know what the equivalent mysql > datatypes are for the following MS SQL datatypes: > > > nvarchar > smallint > bit > int > ntext > real > datetime > float > money > smalldatetime > numeric > decimal > > > Thanks all for your help! > Tom > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
