How To Get The Output Of An ODBC Query In American Text Format?

News Knowledge Base
, ,
1

How to change the output format of an ODBC query to the American format?

Issue Description: Need to change the output format from one format into the American format.

Resolution :

  1. Right-click the My Computer icon on your desktop, then click Properties.
  2. Click the Advanced tab, then click Environment Variables.
  3. In User Variables and System Variables, check if there is a variable named NLS_LANG.
  4. If there is an NLS_LANG variable, highlight it and click Edit.
  5. Set the variable value to UTF8; for example, AMERICAN_AMERICA.UTF8
  6. If NLS_LANG environment variable is not present, change the registry settings:
    1. Click Start, then Run
    2. In the Run window, enter Regedit and click OK
    3. Locate one of the following registry key entries:
      • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
  7. HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx
    • where x is the unique number identifying the Oracle home
  8. Add a new key named NLS_LANG with a value including UTF8;
    • Set the variable in this format: NLS_LANG=AMERICAN_AMERICA.UTF8