Talend community forum / [resolved] force float not real tmssqlOutput from double

outlaw77 · 2012-06-26 12:23:14

hi,

How can I force tmssqlOuput to create a float not real field, when creating a table.
Setting DBtype - does nothing !?

thank you!
regards,
Robert

pedro · 2012-06-27 05:38:53

Hi Robert

Sorry. What do you mean "real field"?

Regards,
Pedro

outlaw77 · 2012-06-27 16:27:16

hy Pedro,

sorry, maybe I should have point it more out clearly.
I mean the database type "real" (mssql). But it should be float.

Thank you!
robert

Uploaded Images

pedro · 2012-06-28 04:01:00

Hi

That's because in MSSQL the 'real' data type is equal to float(24).
If you want float type, modify the length of this column larger than 24.

Regards,
Pedro

outlaw77 · 2012-06-28 08:57:35

hy Pedro!

Thank you for the answer & solution!
regards,
Robert

Announcement

Unanswered posts

#1 2012-06-26 12:23:14

[resolved] force float not real tmssqlOutput from double

#2 2012-06-27 05:38:53

Re: [resolved] force float not real tmssqlOutput from double

#3 2012-06-27 16:27:16

Re: [resolved] force float not real tmssqlOutput from double

#4 2012-06-28 04:01:00

Re: [resolved] force float not real tmssqlOutput from double

#5 2012-06-28 08:57:35

Re: [resolved] force float not real tmssqlOutput from double

Board footer