Re: Negative numbers in MySQL -> MS SQL conversion

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by Dave on July 29 2007 17:40:36:

In Reply to: Negative numbers in MySQL -> MS SQL conversion posted by Ben Fox on July 29 2007 11:32:42:

Hi Ben,

There's a known error with MySql that occur sometimes with tinyint (and maybe smallint in your case) with negative values.
Don't use tinyint to export negative values from MySql. Convert your MySql column to int (or maybe smallint) before exporting the values so they will be correctly extracted.
Generate the script and if you wish to keep smallint as column format you can do so by editing the table structure in the script from int to smallint. With smallint negative values should be correctly be inserted in MS SQL.

Dave.

> Hi,
>
> I have a MySQL smallint column containing negative numbers (mainly -1). When converting to MS SQL, the tool appears to convert the -1 to 255 (thus breaking my application).
>
> Is this a known bug in version 1.6.0.15?
>
> Regards,
>
> Ben

Follow Ups:

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> Hi Ben, > > There's a known error with MySql that occur sometimes with tinyint (and maybe smallint in your case) with negative values. > Don't use tinyint to export negative values from MySql. Convert your MySql column to int before exporting the values so they will be correctly extracted. > Generate the script and if you wish to keep smallint as column format you can do so by editing the table structure in the script from int to smallint. With smallint negative values should be correctly be inserted in MS SQL. > > Dave. > > > Hi, > > > > I have a MySQL smallint column containing negative numbers (mainly -1). When converting to MS SQL, the tool appears to convert the -1 to 255 (thus breaking my application). > > > > Is this a known bug in version 1.6.0.15? > > > > Regards, > > > > Ben >

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]