DBeaver - Number values formatted in thousands by default.

[NyaNguyen]

Hi,

Is there a setting that allows us to disable the thousands number formatting in our cells?

Ex.: My database value for cell X is 34567 and it is displayed as 34,567 in DBeaver. I'd rather set it to show the raw value with no formatting.

Thank you!

[serge-rider]

You can change numbers/datetime formats in Preferences:

[JoeCheez]

Because they significantly reorganized the Preferences menu and I had to spend 10 minutes looking for it again.

[potback]

Because they significantly reorganized the Preferences menu and I had to spend 10 minutes looking for it again.

Just a tip: since the IDE is just eclipse in desguise, you can use the 'type filter text' box, type in 'data formats' and it will show you where the menu item is ;-)

[EskeRahn]

Things have been rearranged slightly again, so now "Editors" is one level higher up in the tree, so do not look for "Database".

[chephei]

For dbeaver 7.3.0 on Linux
select in Type = number and unmark use grouping

[cies]

On DBeaver 21.1.3 (Linux) I did this: in Window > Preferences > Editors > Data Editor > Data Formats check the box for "Disable numeric formatting"

[kajdo]

have a nice day from a german UI

[cloghin]

Is there a way to maintain the group separators in the TEXT version of the result set ? I see it in GRID, but then the TEXT tab does not show it. I use it to copy paste the entire result set with headers in a simple way.

[cloghin]

Answered my own question : change Value display format from Editable to Display(default)