7

I use version 3.4.0 of SQuirreL SQL client, and whenever I execute a request that returns numbers (IDs for example), the result numbers are formatted with commas, i.e. 123,456,789 instead of plain 123456789. How can I change this formatting, so that there are no more commas?

zb226
  • 9,586
  • 6
  • 49
  • 79
Bubolina
  • 141
  • 2
  • 16

1 Answers1

11

Sure can do:

  • Open the "File" menu
  • Select "Global preferences"
  • Select the "Data Type Controls" tab
  • Scroll all the way down
  • The last section deals with "FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL (SQL types 6, 7, 8, 2, 3)". There, select the "default format" option. See also this screenshot:

SquirrelSQL Data Type Controls

zb226
  • 9,586
  • 6
  • 49
  • 79