When I create a column of type “number” within Servoy and later look at the same column within Sybase Central the column is of type “double”.
From within Servoy when I import “2,400” into the same column it comes in as “2.4”. How can I correct this so that the imported number shows as “2,400”?
Sounds to me this is some locale issue (number format) where commas and periods are reversed.
Check what Servoy is using but also what the database server is using.
Hope this helps.
I am still unclear on this. Is it correct for Sybase to create a column of type “double” when the column is originally created within Servoy as type “number”?
I tried exporting the solution, deleting the column and then importing the solution and Servoy again created the column as type “number” within Servoy and again it shows up as type “double” in Sybase. Is that expected behavior?
My initial experimenting with importing into this column shows “2,400” always coming in as “2.4” unless the import is specified to include a decimal, such as “2,400.00”, then it imports correctly as “2,400”.
I see that Sybase has more data type options than Servoy. They have one named “numeric”. So I guess my question is whether it is correct for a “number” column created from within Servoy to end up being a “double” when viewed from within Sybase Central; or should it show as “numeric” within Sybase Central?
I am concerned about how easy it is to end up with incorrect numeric data following an import.
Windows XP Professional
Servoy Version R2 2.2 1-build 333
Westy:
I am still unclear on this. Is it correct for Sybase to create a column of type “double” when the column is originally created within Servoy as type “number”?
Yes, it’s OK
From the ianywhere manual:
The value range is 2.22507385850721e-308 to 1.79769313486231e+308. Values held as DOUBLE are accurate to 15 significant digits
Westy:
I see that Sybase has more data type options than Servoy. They have one named “numeric”. So I guess my question is whether it is correct for a “number” column created from within Servoy to end up being a “double” when viewed from within Sybase Central; or should it show as “numeric” within Sybase Central?
Yes, each db has it’s own data types… but I would suggest to use the ones defined by Servoy… so you will be able to deploy your applications to different db without problems.
Thank you for the responses. It is a relief to know that my database is okay in this regard. I will just have to be careful formatting numeric data prior to import.