Member Avatar for watchinthegame

MYSQL field is Datatype DECIMAL(9,2)
When I update the table and set the field to 120.00 it gets populated as 1200.00

What am I doing wrong?

Thanks

Watchin

  • 3 Contributors
  • 2 Replies
  • 90 Views
  • 5 Months Discussion Span
  • Latest Post Latest Post by elbiggame
Member Avatar for darkagn

Hi watchinthegame and welcome to DaniWeb :)

This is a bit odd. Can you please post your SQL query that you are using to update the record so we can take a look?

Cheers
d

Member Avatar for elbiggame

MYSQL field is Datatype DECIMAL(9,2)
When I update the table and set the field to 120.00 it gets populated as 1200.00

What am I doing wrong?

Thanks

Watchin

Did you ever resolve your issue? I'm having the same issue with mysql 5.0 database table decimal fields. I restored tables from a prior version. Backups and restores worked perfect. All my existing programs (I've been running for several years w/ no problem) are executing the same except decimal digits are moving to the left of decimal place. The table definitions look identical to old mysql tables.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.