471,090 Members | 1,385 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

MySQL & Powerbuilder problem

Hi,

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
platforms.
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
consequences.
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?

Thanks,
Gerry.
Powerbuilder 10.2
MySQL 5.0.4 beta
MyODBC 3.51.11-2

Jul 23 '05 #1
0 1886

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by iwasinnihon | last post: by
3 posts views Thread by Pino | last post: by
9 posts views Thread by Norm Goertzen | last post: by
4 posts views Thread by VMI | last post: by
5 posts views Thread by =?Utf-8?B?Q2F0c0NyYWRsZQ==?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.