Monday, February 8, 2010

Disable SquirrelSQL Commas In Integers

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

AddThis

Bookmark and Share