Specifies the client-side character set for the current environment handle.
O90 Oracle9i
O10 Oracle 10g
NLS_Charset='value'
NLS_Charset='Unicode'
When you specify a value for NLS_Charset, DataWindow Designer sets the OCI NLS_CHARACTERSET property in the current connection. NLS_CHARACTERSET is a database parameter that specifies the character set encoding used to store CHAR, VARCHAR2, LONG, and CLOB datatypes. The value you set corresponds to the character set defined by the NLS_LANG client-side parameter. NLS_LANG defines the character set encoding of text that OCI gets from or sends to applications in bind or define variables or as SQL statements to be executed by the server.
For the Oracle national character set NLS_NCHAR_CHARACTERSET, the O10 and O90 database interfaces always use the UTF-16 character set.
For EAServer connections, you can use only Unicode or Local. For COM+ connections, you can use only Local.
To specify that the OCI client should use the current character set defined by the NLS_LANG parameter on the local computer to store string datatypes:
Database profile Select Local from the NLS Charset drop-down list on the System page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DbParameter="NLS_Charset='Local'"
