I've migrated the database from SQL Anywhere 6.0 to 12.0. I'm having problems with the numeric format in the newer version.
In my old database, the numbers are inserted without any commas, for example "36001.35", but after the migration, the format becomes "36,001.35", it is disturbing the data output in my application. How can I migrate the data from old database to the new database and keep the same format? Please let me know soon. Thanks.
Edit: I just found out that the format can be controlled from the datawindow source. If I see the source of window in the Powerbuilder, there is format specified format="#, ##0.00", and so I can change the format to format="###0.00". Now my question is, is it the proper way to change the format ?(ie. to Edit the source of each of the datawindow? Or there is some general setting/way to do same thing for whole application at once?
I would think that this is merely a formatting issue and does not affect the stored data - as long as you are using a numerical data type instead of text.
AFAIK, newer versions (v10/v11?) of DBISL and Sybase Central display numbers formatted as specified in the user's or system's regional settings - therefore adding the thousand separator. In contrast, older versions (and the current dbisqlc) just display numerical data in the standard SQL format (i.e. just a decimal point). The underlying data are not affected by this difference in displaying numbers.
(Sorry, I can't tell on the PowerBuilder question.)
answered 17 Jan '12, 05:55