Do you have a question? Post it now! No Registration Necessary. Now with pictures!
May 29, 2005, 9:39 am
rate this thread
I am not quite sure where to place this question, by Powerbuilder or
MySQL as I guess it is a communication glitch between the two
I am trying to convert a Powerbuilder application from Sybase SQLA to
MySQL. I have created a new database, exported the Sybase data and
imported it into MySQL. The original datawindows still work fine. So
far, so good, but if the datawindows are regenerated then all decimal
and numeric fields containing decimal places are changed to char!
Decimal(5,2) changes from decimal(2) to char(5) with all the bizarre
If I edit the dw source and change the char(5) back to decimal(2) then
it works again.
I gather that MySQL has changed the method of storing decimal fields
after 5.0.3 so maybe Powerbuilder hasn't caught up yet.
Any comments anyone?
MySQL 5.0.4 beta
- » 3.25 rate confirmation #033526FAW Sun, 29 May 2005 01:51:02 -0800
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum