CODEWITHSUNDEEP
oracle-database
sqlpractice
sqlpractice

Reputation: 141

Special Characters not getting displayed in Oracle tables

I have data which contains special characters like à ç è etc..

I am trying to insert the data into tables having these characters. Data gets inserted without any issues but these characters are replaced with with ?/?? when stored in tables

How should I resolve this issue?I want to store these characters in my tables.

Is it related to NLS parameters? Currently the NLS characterset is having AL32UTF8 as seen from V$Nls_parameters table.

Is there any specific table/column to be checked ? Or is it something at the database settings ?

Kindly advise.

Thank in advance

Upvotes: 1

Views: 4449

Answers (1)

Wernfried Domscheit
Wernfried Domscheit

Reputation: 59436

From the comments: It is not required that column must be NVARCHAR (resp. NVARCHAR2), because your database character set is AL32UTF8 which supports any Unicode character.

Set your NLS_LANG variable to AMERICAN_AMERICA.AL32UTF8 before you launch your SQL*Plus. You may change the language and/or territory to your own preferences.

Ensure you select a font which is able to display the special characters.

Note, client character set AL32UTF8 is determined by your local LANG variable (i.e. en_US.UTF-8), not by the database character set.

Check also this answer for more information: OdbcConnection returning Chinese Characters as "?"

Upvotes: 1

Related Questions