SqlDbx Forum

SqlDbx

You are not logged in.

#1 2019-07-18 07:39:07

AndrewMurphy
Member

SQLDBX & NSL_LANG & Euro Symbol.

I'm using SQLDBX (4.3 Pro).

I want to be able to display (in the IDE) the € (Euro) symbol which is saved in VARCHAR2 column within an ORACLE database created with settings.
NLS_LANGUAGE            AMERICAN
NLS_TERRITORY    AMERICA
NLS_CHARACTERSET    AL32UTF8
NLS_RDBMS_VERSION    10.2.0.4.0
Changing any of these settings is not an option that can be easily considered.


I can change my session variables for NLS_LANGUAGE & NLS_TERRITORY on the fly, but the NLS_CHARACTERSET can't be set on the fly... all the documentation I read says it must be set before the IDE is launched...my question is "how & where"?

If I invoke SQLPLUS from a "Windows Powershell" per below

chcp 1252               # 1252 & 850 both work
$env:NLS_LANG='AMERICAN_AMERICA.AL32UTF8'  #set to ensure the client settings match the DB settings
#without the above 2 settings I get gibberish or unknown characters for the €, the client (Windows 10 PC), appears to have a default of some other value....
sqlplus myuser/mypass@myoracle @mysql.sql

I can see then the € sysbol fine within the output text within the PowerShell screen....

But I can't work out how to see the € character within the results of the IDE....the  € can be typed into the script section of the IDE without problem.

Offline

Board footer

Powered by FluxBB