[Koha-bugs] [Bug 32595] Price format cost in ILL requests table

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32595

--- Comment #12 from Pedro Amorim <pedro.amorim at ptfs-europe.com> ---
(In reply to Katrin Fischer from comment #11)

Correct, I noticed that too. The replacing of , -> . is visual only and to
ensure compatibility with existing data, because there's no telling what may
exist currently on live databases.

We could come up with an atomic update like:
1) UPDATE illrequests SET price_paid = CAST(REPLACE(price_paid, ',', ',') as
DECIMAL(28,6))
2) ALTER TABLE illrequests MODIFY price_paid DECIMAL(28,6)

But this may cause issues as there may be non-numeric data in current
databases?

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.