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.
| Author |
Topic |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2007-03-20 : 10:16:42
|
| Does anyone know of a reference site where I can find a reference table to get a better idea of data type conversions that I should be using? I have a MySQL 5.0 database which had a lot of tables (mostly empty) that I already have gotten transferred to SQL Server 2005. However, I am suspicious of some of the data type conversions that SQL Server did. I would really like a good web site to bookmark to help me with this if there is such a reference. Can anyone help?If not, the most specific example I have right now is a MySQL column that is expecting to accept currency and the MySQL data type is "Double". SQL Server 2005 translated this as a "float" data type. I normally use a "decimal" data type.- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://www.servicerank.com/ |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-20 : 11:04:02
|
| What do MySQL help file say about DOUBLE data type? Which range of numbers do it cover?When knowing that, it si very easy to select a datatype in SQL server to do exact same thing.Peter LarssonHelsingborg, Sweden |
 |
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2007-03-20 : 12:39:33
|
| Thank you! I really should have thought of that on my own. Double is not a good field for currency if you expect to have more than $2.23 in the field. :)- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://www.servicerank.com/ |
|
|
|
|
|
|
MySQL to SQL Server 2005 Conversion Table