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?
Asked
Active
Viewed 6,652 times
7
1 Answers
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:

zb226
- 9,586
- 6
- 49
- 79