Viewing entries tagged
CSSCAN

1 Comment

2014-07 – Changing the Database Character Set

The NLS_CHARACTERSET of an Oracle database defines what characters can be stored in the database using the CHAR, VARCHAR2, LONG and CLOB datatypes. This blog gives a quick overview of a method to change the database character set or to check before migrating data between databases with a different NLS_CHARACTERSET.

If you change character sets there is a possibility that characters that you currently use are not defined in the new character set or that the current setup is not correctly used and therefore you could lose data when changing the NLS_CHARACTERSET.

In previous blog “2014-06 – Database Character Set Scanner”, we addressed how to install a great Oracle tool called CSSCAN. Always check data migration by using the Character Set Scanner (CSSCAN) before making any changes to your character set.

1 Comment

Comment

2014-06 – Database Character Set Scanner

Designing and setting up a new database system can take a lot of planning. But typically, one important decision is overlooked: choosing the right character set. A basic consideration for choosing a character set is to make sure it can handle any language that needs to be supported immediately and in the future. Oracle has documentation on the capabilities and performance implications of different character sets (Choosing a Character Set). Sometimes you have to change the database character set to support a new application.

Comment