Numbers format problem after migrating database

[Former Member]

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?

[reimer_pods]

Where do you see that format, in your application or when using ISQL or Sybase Central do display data?

[Former Member]

@Reimer Pods, I edited the question, please see above. I checked old data in the iSQL while the migrated data in the Sybase Central.

[reimer_pods]

The display or edit format should be independent of the representation used by database administration tools. When we switched from ASA9 to SA12, we didn't notice any change in datawindow formatting (PB 9).
Anyway, I think an PowerBuilder newsgroup would be more appropriate for this kind of question (PB Resources)

[VolkerBarth · Accepted solution]

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.)

[former_SQLA_member1694880 · Accepted solution]

Since V10, ISQL formats numbers using commas as a thousand separator (it is not a thousand separator from the regional settings). However, it is not a big deal, so I've never made fuss out of it.

[VolkerBarth · Accepted solution]

Well, at least DBISQL v12 does use localized number formatting - in my case, according to the "de-DE" locale with a point as thousand separator and a decimal comma. - But as you say, no big deal:)