DECIMAL data types are not converting to SQL Server decimal data types correctly.
I reported in the forum that conversion of DECIMAL data types from Ingres to SQL Server was missing the number of decimals. ie DECIMAL(7,5) became DECIMAL(7,0) when converted.
Rob responded -
"The SQLServer dialect is missing the scale placeholder ($s) that should be present for DECIMAL types.
You can also see this if you create the table in SQLServer correctly (that is, decimal(7,5)) and try to create a script from it.
It yields decimal(7). I believe this bug has been present in 2.6.x and possibly before that. Please write it up and it will get
fixed shortly"
From Eric Whitchurch
MailTo: ewh71856@bigpond.net.au
Log in to post a comment.
