database-migration icon indicating copy to clipboard operation
database-migration copied to clipboard

Max precision in sql server is 38

Open Fredehagelund92 opened this issue 7 years ago • 0 comments

I've had issues with numeric and decimal since max precision in sql server is 38 and in exasol 36, i've made quick fix by adding this case when PRECISION > 36 then 36 else PRECISION end.

Then i've added binary bwith this line

when 173 then '"' || column_name || '"' ||' ' ||'VARCHAR(2000000)' --binary

Fredehagelund92 avatar May 18 '17 08:05 Fredehagelund92