Home » SQL & PL/SQL » SQL & PL/SQL » Polish Characters are missing through the SQLPLUS (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production)
Polish Characters are missing through the SQLPLUS [message #669372] Wed, 18 April 2018 02:35 Go to next message
saipradyumn
Messages: 400
Registered: October 2011
Location: Hyderabad
Senior Member

Hi All,

I have DMLStatements which contains some polish characters for POLAND country.
When i am executing that DML through the QL Developer i am able to see my Polishcharacters.

but when we gave the release through the SQLPLUS those characters are replacing with some special characters
like ? (Question Mark)


Data type of the column is : NCLOB
NLS_CHARACTERSET : AL32UTF8
NLS_NCHAR_CHARACTERSET : AL16UTF16

Could you please help to resolve this

Thanks
SaiPradyumn

Re: Polish Characters are missing through the SQLPLUS [message #669388 is a reply to message #669372] Thu, 19 April 2018 07:03 Go to previous messageGo to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
Have a look at set NLS_LANG for SQLPLUS on windows
and nls_lang faq
Re: Polish Characters are missing through the SQLPLUS [message #669443 is a reply to message #669388] Mon, 23 April 2018 04:44 Go to previous message
saipradyumn
Messages: 400
Registered: October 2011
Location: Hyderabad
Senior Member
Hi
Thanks FLYBY.

After setting the following commands in the linux machine
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_LANG

Thanks
SaiPradyumn
Previous Topic: Need Help In Dates
Next Topic: Handle return empty cursor in SP output parameter
Goto Forum:
  


Current Time: Fri Sep 18 06:36:47 CDT 2020