Title: Decimal Fields Again
Last modified: March 16, 2018

---

# Decimal Fields Again

 *  [supernova42](https://wordpress.org/support/users/supernova42/)
 * (@supernova42)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/decimal-fields-again/)
 * Hi Roland
    I want to change the decimal accuracy of my decimal fields and you
   advised that I can change the precision of the decimal field by editing the field
   datatype in the database directly using phpMyAdmin. This post discusses setting
   up the datatype: [https://xnau.com/setting-up-a-currency-or-other-decimal-type-field/](https://xnau.com/setting-up-a-currency-or-other-decimal-type-field/)
 * The default accuracy was 14,4 for the fields in question. I changed these to 
   10,6 which would allow values of 180.123456. For some reason, after I change 
   the fields using phpMyAdmin the fields later change back to their initial value
   of 14,4. So what am I doing wrong and how do I permanently change the accuracy
   of these fields?
    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [xnau webdesign](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/decimal-fields-again/#post-10084185)
 * Thanks for pointing this out, I plan to have a way to prevent the customized 
   datatype from getting changed…this will happen if other parameters of the field
   definition are changed: it will revert back to the default value. It shouldn’t
   do that.
 *  Thread Starter [supernova42](https://wordpress.org/support/users/supernova42/)
 * (@supernova42)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/decimal-fields-again/#post-10085482)
 * Does the latest Participants Database upgrade resolve this problem Roland.
    i.
   e. customized datatype parameters won’t be reverted when the field definition
   is saved #1717 Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Decimal Fields Again’ is closed to new replies.

 * ![](https://ps.w.org/participants-database/assets/icon-256x256.jpg?rev=1389807)
 * [Participants Database](https://wordpress.org/plugins/participants-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/participants-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/participants-database/)
 * [Active Topics](https://wordpress.org/support/plugin/participants-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/participants-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/participants-database/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [supernova42](https://wordpress.org/support/users/supernova42/)
 * Last activity: [8 years, 2 months ago](https://wordpress.org/support/topic/decimal-fields-again/#post-10085482)
 * Status: not resolved