Often when just installed a new tool, you will find that proven sql’s is not working. Reson for this can be your registry nls_lang is defaulted to the windows language.
- open regedit
- find all occurences of “NLS_LAN”
- update to “AMERICAN_AMERICA.UTF8″
This is with NLS_LANG = DANISH_DENMARK.UTF8:
DEV> select userenv('LANG') from dual; DK ForlÃ¸bet: 00:00:00.00 DEV>
This is with NLS_LANG = AMERICAN_AMERICA.UTF8:
DEV> select userenv('LANG') from dual; US DEV>