When you query using Squirrel numeric types are returned with commans (1,234,567) instead of simple numbers (1234567) which makes them easier to read, but not so great for copy/pasting into other queries. The
SquirrelSQL FAQ tells us how to change that functionality:
- Open Global Preferences from the File menu
- Click on Data Type Control tab.
- Scroll down to the "FLOAT, REAL, DOUBLE, NUMERIC" section
- Select "Use default format".
No comments
Post a Comment