Setting Code Attribute UNICODE (SAP Library - The SAP DB Database System:)

Setting Code Attribute UNICODE

To be able to store the application data in UNICODE, the database must be UNICODE-enabled and you must set the code attribute UNICODE for the required application data (Installing a UNICODE-Enabled Database). You can set the code attribute in the following ways:

Database parameter DEFAULT_CODE is not set to value UNICODE.
In the column definition, make sure you enter code attribute UNICODE. Application data is then only stored in UNICODE for these column values.
If you do not enter a code attribute, the code entered in the parameter DEFAULT_CODE (that is to say, not UNICODE) is used for these column values.

Database parameter DEFAULT_CODE is set to value UNICODE.
In the column definition, enter code attribute UNICODE. Application data is stored in UNICODE for these column values.
If you do not enter a code attribute, the application data is stored in UNICODE for these column values, because the parameter DEFAULT_CODE is set to UNICODE.

Example

Database parameter DEFAULT_CODE is set to value UNICODE.

Column definition	Result
CHAR (n) UNICODE	UNICODE column
CHAR (n)	UNICODE column
CHAR (n) ASCII	ASCII column
CHAR (n) BYTE	Code neutral, i.e. the column values are not converted by the database system

For information on setting database parameters, see the following documentation:

Database Manager GUI: SAP DB 7.4, Section Displaying and Changing Current Database Parameters

Database Manager CLI: SAP DB 7.4, Section Changing the Value of a Database Parameter