-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
NLS_CHARACTERSET is used for CHAR, VARCHAR2, CLOB columns and NLS_NCHAR_CHARACTERSET is used for NCHAR, NVARCHAR2, NCLOB columns. One can find… READ MORE
One can use the following v$nls_parameters view to find the database LANGUAGE, TERRITORY, and CHARACTER SET. READ MORE
Last updated: 17-Nov-2008 When exporting/importing one can minimize risk of losing data during import/export by setting NLS_LANG. – Before starting… READ MORE
NLS_LANG=<language>_<territory>.<character set> Example: export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 Setting NLS_LANG tells Oracle what characterset the client is using so Oracle can do conversion… READ MORE
For SQL*Plus to process french accents characters when using SQL*Plus, you would need to set NLS_LANG On Windows set NLS_LANG=.AL32UTF8… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 