SqlDbx
You are not logged in.
Pages: 1
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
Pages: 1