Advice

What is Nclob?

An SQL NCLOB is a built-in type that stores a Character Large Object using the National Character Set as a column value in a row of a database table.

What is Nclob?

An SQL NCLOB is a built-in type that stores a Character Large Object using the National Character Set as a column value in a row of a database table.

What is Oracle Csscan?

For 8i and 9i please do install Csscan version 1.2 , do not use the old csscan versions included in 8i/9i . The Csscan tool analyzes the code points in the database and verifies that they are known in the source the database characterset and known in the target database characterset.

What is DMU in Oracle?

Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode.

How to change from al32utf8/utf8 to other characterset?

While this note is written for going to AL32UTF8/UTF8 most of the facts are also applicable when changing to any other Multibyte characterset (ZHS16GBK, ZHT16MSWIN950, ZHT16HKSCS, ZHT16HKSCS31,KO16MSWIN949, JA16SJIS …), simply substitute AL32UTF8 with the xx16xxxx target characterset.

What is the current NLS_characterset?

The current NLS_CHARACTERSET is seen in NLS_DATABASE_PARAMETERS. The NLS_CHARACTERSET is defining the characterset of the CHAR, VARCHAR2, LONG and CLOB datatypes. Details Sign In

What is the difference between NLS_charset_ID and Char_CS?

NLS_CHARSET_ID returns the character set ID number corresponding to character set name string. The string argument is a run-time VARCHAR2 value. The string value ‘ CHAR_CS ‘ returns the database character set ID number of the server. The string value ‘ NCHAR_CS ‘ returns the national character set ID number of the server.

What might silently truncate data in AL32UTF8 DB?

B.16) Character functions that are returning character values might silently truncate data. B.17) Column size double or triple when using (Materialized) Views / CTAS in an AL32UTF8 db and the dblink points to a non-AL32UTF8 db (or inverse).