https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32595
--- Comment #12 from Pedro Amorim <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
