Home How To Online Documentation Support Download Order

 

 

 

SACommand
SAConnection
SAException
SAField
SAParam

SAString
SADateTime
SANumeric
SAInterval

Enums and Typedefs

  

Usage

Class Members

Examples

SAParam::setOption

SAString &setOption(const SAString &sOptionName);

Sets a string value of a specific parameter option.

Parameters

sOptionName.    A string key of the parameter option.

Remarks

Call this method to set value(s) of server specific parameter options. See Server specific notes.

A parameter related option may be specified in SAConnection object, SACommand object or SAParam object. If it is specified in SAConnection object it affects all the commands and therefore all the parameters on that connection. If it is specified in SACommand object it affects all the parameters on that command.

If an option is not specified in SAConnection, SACommand and SAParam objects, the Library takes the default option's value.

setOption method is safe to use in cross-server applications. An option related to a particular server does not affect others. 

Server specific notes

DBMS client

Specific field options 

Oracle

OCI_ATTR_CHARSET_ID
This option sets the character set ID of the parameter.
Parameter related. Should be specified before command execution.
Valid values: String containing Oracle character set name ("US7ASCII", "CL8MSWIN1251", "SF7DEC", etc.) or its numeric value ("1", "171", "21", etc.). See Oracle documentation for more details.
By default SQLAPI++ doesn't change Oracle settings for this option. See Oracle documentation for details.

OCI_ATTR_CHARSET_FORM
This option sets the character set form of the parameter.
Parameter related. Should be specified before command execution.
Valid values: "SQLCS_IMPLICIT", "SQLCS_NCHAR". See Oracle documentation for more details.
By default SQLAPI++ doesn't change Oracle settings for this option. See Oracle documentation for details.

SQL Server (OLE DB)

None

SQL Server (DB-Library)

None

Sybase

None

DB2

None

Informix

None

InterBase

None

SQLBase

None

MySQL

None

PostgreSQL

None

ODBC

None

See also

Option

SAConnection::Option, SAConnection::setOption, SACommand::Option, SACommand::setOption

SAConnection, SACommand

Problems and Questions

If you haven't found the answer to your questions or have some problems on using the Library, please, send e-mail to howto@sqlapi.com.