Question Re: Numbers format problem after migrating database in Technology Q&A

Numbers format problem after migrating database

Former Member — Tue, 17 Jan 2012 02:38:07 GMT

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?

Re: Numbers format problem after migrating database

reimer_pods — Tue, 17 Jan 2012 04:51:55 GMT

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

Re: Numbers format problem after migrating database

Former Member — Tue, 17 Jan 2012 05:32:12 GMT

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

Re: Numbers format problem after migrating database

VolkerBarth — Tue, 17 Jan 2012 05:55:18 GMT

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

Re: Numbers format problem after migrating database

former_SQLA_member1694880 — Tue, 17 Jan 2012 06:30:28 GMT

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.

Re: Numbers format problem after migrating database

VolkerBarth — Tue, 17 Jan 2012 06:39:52 GMT

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

Re: Numbers format problem after migrating database

reimer_pods — Tue, 17 Jan 2012 06:59:14 GMT

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)