Inheritance diagram for Zend_Db_Adapter_Sqlsrv:

Public Member Functions
	setTransactionIsolationLevel ($level=null)

	isConnected ()

	closeConnection ()

	prepare ($sql)

	lastInsertId ($tableName=null, $primaryKey=null)

	insert ($table, array $bind)

	listTables ()

	describeTable ($tableName, $schemaName=null)

	setFetchMode ($mode)

	limit ($sql, $count, $offset=0)

	supportsParameters ($type)

	getServerVersion ()

Public Member Functions inherited from Zend_Db_Adapter_Abstract
	__construct ($config)

	getConnection ()

	getConfig ()

	setProfiler ($profiler)

	getProfiler ()

	getStatementClass ()

	setStatementClass ($class)

	query ($sql, $bind=array())

	beginTransaction ()

	commit ()

	rollBack ()

	insert ($table, array $bind)

	update ($table, array $bind, $where='')

	delete ($table, $where='')

	select ()

	getFetchMode ()

	fetchAll ($sql, $bind=array(), $fetchMode=null)

	fetchRow ($sql, $bind=array(), $fetchMode=null)

	fetchAssoc ($sql, $bind=array())

	fetchCol ($sql, $bind=array())

	fetchPairs ($sql, $bind=array())

	fetchOne ($sql, $bind=array())

	quote ($value, $type=null)

	quoteInto ($text, $value, $type=null, $count=null)

	quoteIdentifier ($ident, $auto=false)

	quoteColumnAs ($ident, $alias, $auto=false)

	quoteTableAs ($ident, $alias=null, $auto=false)

	getQuoteIdentifierSymbol ()

	lastSequenceId ($sequenceName)

	nextSequenceId ($sequenceName)

	foldCase ($key)

	__sleep ()

	__wakeup ()

	listTables ()

	describeTable ($tableName, $schemaName=null)

	isConnected ()

	closeConnection ()

	prepare ($sql)

	lastInsertId ($tableName=null, $primaryKey=null)

	setFetchMode ($mode)

	limit ($sql, $count, $offset=0)

	supportsParameters ($type)

	getServerVersion ()

Protected Member Functions
	_connect ()

	_checkRequiredOptions (array $config)

	_quote ($value)

	_beginTransaction ()

	_commit ()

	_rollBack ()

Protected Member Functions inherited from Zend_Db_Adapter_Abstract
	_checkRequiredOptions (array $config)

	_whereExpr ($where)

	_quote ($value)

	_quoteIdentifierAs ($ident, $alias=null, $auto=false, $as=' AS ')

	_quoteIdentifier ($value, $auto=false)

	_connect ()

	_beginTransaction ()

	_commit ()

	_rollBack ()

Protected Attributes
	$_config

	$_lastInsertId

	$_lastInsertSQL = 'SELECT SCOPE_IDENTITY() as Current_Identity'

	$_numericDataTypes

	$_defaultStmtClass = 'Zend_Db_Statement_Sqlsrv'

Protected Attributes inherited from Zend_Db_Adapter_Abstract
	$_config = array()

	$_fetchMode = Zend_Db::FETCH_ASSOC

	$_profiler

	$_defaultStmtClass = 'Zend_Db_Statement'

	$_defaultProfilerClass = 'Zend_Db_Profiler'

	$_connection = null

	$_caseFolding = Zend_Db::CASE_NATURAL

	$_autoQuoteIdentifiers = true

	$_numericDataTypes

	$_allowSerialization = true

	$_autoReconnectOnUnserialize = false

Detailed Description

Definition at line 40 of file Sqlsrv.php.

Member Function Documentation

◆ _beginTransaction()

_beginTransaction ( )

protected

Leave autocommit mode and begin a transaction.

Returns: void

Exceptions

Zend_Db_Adapter_Sqlsrv_Exception

Definition at line 527 of file Sqlsrv.php.

     {
         if (!sqlsrv_begin_transaction($this->_connection)) {
             #require_once 'Zend/Db/Adapter/Sqlsrv/Exception.php';
             throw new Zend_Db_Adapter_Sqlsrv_Exception(sqlsrv_errors());
         }
     }

◆ _checkRequiredOptions()

_checkRequiredOptions ( array $config )

protected

Check for config options that are mandatory. Throw exceptions if any are missing.

Parameters

array $config

Exceptions

Zend_Db_Adapter_Exception

See also: Zend_Db_Adapter_Exception; Zend_Db_Adapter_Exception; Zend_Db_Adapter_Exception

Definition at line 179 of file Sqlsrv.php.

     {
         // we need at least a dbname
         if (! array_key_exists('dbname', $config)) {
             #require_once 'Zend/Db/Adapter/Exception.php';
             throw new Zend_Db_Adapter_Exception("Configuration array must have a key for 'dbname' that names the database instance");
         }
 
         if (! array_key_exists('password', $config) && array_key_exists('username', $config)) {
             #require_once 'Zend/Db/Adapter/Exception.php';
             throw new Zend_Db_Adapter_Exception("Configuration array must have a key for 'password' for login credentials.
                                                 If Windows Authentication is desired, both keys 'username' and 'password' should be ommited from config.");
         }
 
         if (array_key_exists('password', $config) && !array_key_exists('username', $config)) {
             #require_once 'Zend/Db/Adapter/Exception.php';
             throw new Zend_Db_Adapter_Exception("Configuration array must have a key for 'username' for login credentials.
                                                 If Windows Authentication is desired, both keys 'username' and 'password' should be ommited from config.");
         }
     }

◆ _commit()

_commit ( )

protected

Commit a transaction and return to autocommit mode.

Returns: void

Exceptions

Zend_Db_Adapter_Sqlsrv_Exception

Definition at line 541 of file Sqlsrv.php.

     {
         if (!sqlsrv_commit($this->_connection)) {
             #require_once 'Zend/Db/Adapter/Sqlsrv/Exception.php';
             throw new Zend_Db_Adapter_Sqlsrv_Exception(sqlsrv_errors());
         }
     }

◆ _connect()

_connect ( )

protected

Creates a connection resource.

Returns: void

Exceptions

Zend_Db_Adapter_Sqlsrv_Exception

See also: Zend_Db_Adapter_Sqlsrv_Exception; Zend_Db_Adapter_Sqlsrv_Exception

Definition at line 113 of file Sqlsrv.php.

     {
         if (is_resource($this->_connection)) {
             // connection already exists
             return;
         }
 
         if (!extension_loaded('sqlsrv')) {
             #require_once 'Zend/Db/Adapter/Sqlsrv/Exception.php';
             throw new Zend_Db_Adapter_Sqlsrv_Exception('The Sqlsrv extension is required for this adapter but the extension is not loaded');
         }
 
         $serverName = $this->_config['host'];
         if (isset($this->_config['port'])) {
             $port        = (integer) $this->_config['port'];
             $serverName .= ', ' . $port;
         }
 
         $connectionInfo = array(
             'Database' => $this->_config['dbname'],
         );
 
         if (isset($this->_config['username']) && isset($this->_config['password']))
         {
             $connectionInfo += array(
                 'UID'      => $this->_config['username'],
                 'PWD'      => $this->_config['password'],
             );
         }
         // else - windows authentication
 
         if (!empty($this->_config['driver_options'])) {
             foreach ($this->_config['driver_options'] as $option => $value) {
                 // A value may be a constant.
                 if (is_string($value)) {
                     $constantName = strtoupper($value);
                     if (defined($constantName)) {
                         $connectionInfo[$option] = constant($constantName);
                     } else {
                         $connectionInfo[$option] = $value;
                     }
                 }
             }
         }
 
         $this->_connection = sqlsrv_connect($serverName, $connectionInfo);
 
         if (!$this->_connection) {
             #require_once 'Zend/Db/Adapter/Sqlsrv/Exception.php';
             throw new Zend_Db_Adapter_Sqlsrv_Exception(sqlsrv_errors());
         }
     }

◆ _quote()

_quote ( $value )

protected

Quote a raw string.

Parameters

string $value Raw string

Returns: string Quoted string

Definition at line 309 of file Sqlsrv.php.

     {
         if (is_int($value)) {
             return $value;
         } elseif (is_float($value)) {
             return sprintf('%F', $value);
         }
 
         $value = addcslashes($value, "\000\032");
         return "'" . str_replace("'", "''", $value) . "'";
     }

◆ _rollBack()

_rollBack ( )

protected

Roll back a transaction and return to autocommit mode.

Returns: void

Exceptions

Zend_Db_Adapter_Sqlsrv_Exception

Definition at line 555 of file Sqlsrv.php.

     {
         if (!sqlsrv_rollback($this->_connection)) {
             #require_once 'Zend/Db/Adapter/Sqlsrv/Exception.php';
             throw new Zend_Db_Adapter_Sqlsrv_Exception(sqlsrv_errors());
         }
     }

◆ closeConnection()

closeConnection ( )

Force the connection to close.

Returns: void

Definition at line 271 of file Sqlsrv.php.

     {
         if ($this->isConnected()) {
             sqlsrv_close($this->_connection);
         }
         $this->_connection = null;
     }

◆ describeTable()

describeTable	(	$tableName,
		$schemaName = `null`
	)

Returns the column descriptions for a table.

The return value is an associative array keyed by the column name, as returned by the RDBMS.

The value of each array element is an associative array with the following keys:

SCHEMA_NAME => string; name of schema TABLE_NAME => string; COLUMN_NAME => string; column name COLUMN_POSITION => number; ordinal position of column in table DATA_TYPE => string; SQL datatype name of column DEFAULT => string; default expression of column, null if none NULLABLE => boolean; true if column can have nulls LENGTH => number; length of CHAR/VARCHAR SCALE => number; scale of NUMERIC/DECIMAL PRECISION => number; precision of NUMERIC/DECIMAL UNSIGNED => boolean; unsigned property of an integer type PRIMARY => boolean; true if column is part of the primary key PRIMARY_POSITION => integer; position of column in primary key IDENTITY => integer; true if column is auto-generated with unique values

Todo:: Discover integer unsigned property.

Parameters

string	$tableName
string	$schemaName	OPTIONAL

Returns: array

Discover metadata information about this table.

Discover primary key column(s) for this table.

Definition at line 433 of file Sqlsrv.php.

     {
         $sql    = "exec sp_columns @table_name = " . $this->quoteIdentifier($tableName, true);
         $stmt   = $this->query($sql);
         $result = $stmt->fetchAll(Zend_Db::FETCH_NUM);
 
         // ZF-7698
         $stmt->closeCursor();
 
         if (count($result) == 0) {
             return array();
         }
 
         $owner           = 1;
         $table_name      = 2;
         $column_name     = 3;
         $type_name       = 5;
         $precision       = 6;
         $length          = 7;
         $scale           = 8;
         $nullable        = 10;
         $column_def      = 12;
         $column_position = 16;
 
         $tableOwner = $result[0][$owner];
         $sql        = "exec sp_pkeys @table_owner = " . $tableOwner
                     . ", @table_name = " . $this->quoteIdentifier($tableName, true);
         $stmt       = $this->query($sql);
 
         $primaryKeysResult = $stmt->fetchAll(Zend_Db::FETCH_NUM);
         $primaryKeyColumn  = array();
 
         // Per http://msdn.microsoft.com/en-us/library/ms189813.aspx,
         // results from sp_keys stored procedure are:
         // 0=TABLE_QUALIFIER 1=TABLE_OWNER 2=TABLE_NAME 3=COLUMN_NAME 4=KEY_SEQ 5=PK_NAME
 
         $pkey_column_name = 3;
         $pkey_key_seq     = 4;
         foreach ($primaryKeysResult as $pkeysRow) {
             $primaryKeyColumn[$pkeysRow[$pkey_column_name]] = $pkeysRow[$pkey_key_seq];
         }
 
         $desc = array();
         $p    = 1;
         foreach ($result as $key => $row) {
             $identity = false;
             $words    = explode(' ', $row[$type_name], 2);
             if (isset($words[0])) {
                 $type = $words[0];
                 if (isset($words[1])) {
                     $identity = (bool) preg_match('/identity/', $words[1]);
                 }
             }
 
             $isPrimary = array_key_exists($row[$column_name], $primaryKeyColumn);
             if ($isPrimary) {
                 $primaryPosition = $primaryKeyColumn[$row[$column_name]];
             } else {
                 $primaryPosition = null;
             }
 
             $desc[$this->foldCase($row[$column_name])] = array(
                 'SCHEMA_NAME'      => null, // @todo
                 'TABLE_NAME'       => $this->foldCase($row[$table_name]),
                 'COLUMN_NAME'      => $this->foldCase($row[$column_name]),
                 'COLUMN_POSITION'  => (int) $row[$column_position],
                 'DATA_TYPE'        => $type,
                 'DEFAULT'          => $row[$column_def],
                 'NULLABLE'         => (bool) $row[$nullable],
                 'LENGTH'           => $row[$length],
                 'SCALE'            => $row[$scale],
                 'PRECISION'        => $row[$precision],
                 'UNSIGNED'         => null, // @todo
                 'PRIMARY'          => $isPrimary,
                 'PRIMARY_POSITION' => $primaryPosition,
                 'IDENTITY'         => $identity,
             );
         }
 
         return $desc;
     }

◆ getServerVersion()

getServerVersion ( )

Retrieve server version in PHP style

Returns: string

Definition at line 668 of file Sqlsrv.php.

     {
         $this->_connect();
         $serverInfo = sqlsrv_server_info($this->_connection);
 
         if ($serverInfo !== false) {
             return $serverInfo['SQLServerVersion'];
         }
 
         return null;
     }

◆ insert()

insert	(		$table,
		array	$bind
	)

Inserts a table row with specified data.

Parameters

mixed	$table	The table to insert data into.
array	$bind	Column-value pairs.

Returns: int The number of affected rows.

Definition at line 358 of file Sqlsrv.php.

     {
         // extract and quote col names from the array keys
         $cols = array();
         $vals = array();
         foreach ($bind as $col => $val) {
             $cols[] = $this->quoteIdentifier($col, true);
             if ($val instanceof Zend_Db_Expr) {
                 $vals[] = $val->__toString();
                 unset($bind[$col]);
             } else {
                 $vals[] = '?';
             }
         }
 
         // build the statement
         $sql = "INSERT INTO "
              . $this->quoteIdentifier($table, true)
              . ' (' . implode(', ', $cols) . ') '
              . 'VALUES (' . implode(', ', $vals) . ')'
              . ' ' . $this->_lastInsertSQL;
 
         // execute the statement and return the number of affected rows
         $stmt   = $this->query($sql, array_values($bind));
         $result = $stmt->rowCount();
 
         $stmt->nextRowset();
 
         $this->_lastInsertId = $stmt->fetchColumn();
 
         return $result;
     }

◆ isConnected()

isConnected ( )

Test if a connection is active

Returns: boolean

Definition at line 259 of file Sqlsrv.php.

     {
         return (is_resource($this->_connection)
                 && (get_resource_type($this->_connection) == 'SQL Server Connection')
         );
     }

◆ lastInsertId()

lastInsertId	(	$tableName = `null`,
		$primaryKey = `null`
	)

Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.

As a convention, on RDBMS brands that support sequences (e.g. Oracle, PostgreSQL, DB2), this method forms the name of a sequence from the arguments and returns the last id generated by that sequence. On RDBMS brands that support IDENTITY/AUTOINCREMENT columns, this method returns the last value generated for such a column, and the table name argument is disregarded.

Parameters

string	$tableName	OPTIONAL Name of table.
string	$primaryKey	OPTIONAL Name of primary key column.

Returns: string

Definition at line 335 of file Sqlsrv.php.

     {
         if ($tableName) {
             $tableName = $this->quote($tableName);
             $sql       = 'SELECT IDENT_CURRENT (' . $tableName . ') as Current_Identity';
             return (string) $this->fetchOne($sql);
         }
 
         if ($this->_lastInsertId > 0) {
             return (string) $this->_lastInsertId;
         }
 
         $sql = $this->_lastInsertSQL;
         return (string) $this->fetchOne($sql);
     }

◆ limit()

limit	(	$sql,
		$count,
		$offset = `0`
	)

Adds an adapter-specific LIMIT clause to the SELECT statement.

Parameters

string	$sql
integer	$count
integer	$offset	OPTIONAL

Returns: string

Exceptions

Zend_Db_Adapter_Sqlsrv_Exception

See also: Zend_Db_Adapter_Exception

Definition at line 601 of file Sqlsrv.php.

      {
         $count = intval($count);
         if ($count <= 0) {
             #require_once 'Zend/Db/Adapter/Exception.php';
             throw new Zend_Db_Adapter_Exception("LIMIT argument count=$count is not valid");
         }
 
         $offset = intval($offset);
         if ($offset < 0) {
             #require_once 'Zend/Db/Adapter/Exception.php';
             throw new Zend_Db_Adapter_Exception("LIMIT argument offset=$offset is not valid");
         }
 
         if ($offset == 0) {
             $sql = preg_replace('/^SELECT\s/i', 'SELECT TOP ' . $count . ' ', $sql);
         } else {
             $orderby = stristr($sql, 'ORDER BY');
 
             if (!$orderby) {
                 $over = 'ORDER BY (SELECT 0)';
             } else {
                 $over = preg_replace('/\"[^,]*\".\"([^,]*)\"/i', '"inner_tbl"."$1"', $orderby);
             }
 
             // Remove ORDER BY clause from $sql
             $sql = preg_replace('/\s+ORDER BY(.*)/', '', $sql);
 
             // Add ORDER BY clause as an argument for ROW_NUMBER()
             $sql = "SELECT ROW_NUMBER() OVER ($over) AS \"ZEND_DB_ROWNUM\", * FROM ($sql) AS inner_tbl";
 
             $start = $offset + 1;
 
             if ($count == PHP_INT_MAX) {
                 $sql = "WITH outer_tbl AS ($sql) SELECT * FROM outer_tbl WHERE \"ZEND_DB_ROWNUM\" >= $start";
             }
             else {
                 $end = $offset + $count;
                 $sql = "WITH outer_tbl AS ($sql) SELECT * FROM outer_tbl WHERE \"ZEND_DB_ROWNUM\" BETWEEN $start AND $end";
             }
         }
 
         return $sql;
     }

◆ listTables()

listTables ( )

Returns a list of the tables in the database.

Returns: array

Definition at line 396 of file Sqlsrv.php.

     {
         $this->_connect();
         $sql = "SELECT name FROM sysobjects WHERE type = 'U' ORDER BY name";
         return $this->fetchCol($sql);
     }

◆ prepare()

prepare ( $sql )

Returns an SQL statement for preparation.

Parameters

string $sql The SQL statement with placeholders.

Returns: Zend_Db_Statement_Sqlsrv

See also: Zend_Loader

Definition at line 285 of file Sqlsrv.php.

     {
         $this->_connect();
         $stmtClass = $this->_defaultStmtClass;
 
         if (!class_exists($stmtClass)) {
             #require_once 'Zend/Loader.php';
             Zend_Loader::loadClass($stmtClass);
         }
 
         $stmt = new $stmtClass($this, $sql);
         $stmt->setFetchMode($this->_fetchMode);
         return $stmt;
     }

◆ setFetchMode()

setFetchMode ( $mode )

Set the fetch mode.

Todo:: Support FETCH_CLASS and FETCH_INTO.

Parameters

integer $mode A fetch mode.

Returns: void

Exceptions

Zend_Db_Adapter_Sqlsrv_Exception

Definition at line 572 of file Sqlsrv.php.

     {
         switch ($mode) {
             case Zend_Db::FETCH_NUM:   // seq array
             case Zend_Db::FETCH_ASSOC: // assoc array
             case Zend_Db::FETCH_BOTH:  // seq+assoc array
             case Zend_Db::FETCH_OBJ:   // object
                 $this->_fetchMode = $mode;
                 break;
             case Zend_Db::FETCH_BOUND: // bound to PHP variable
                 #require_once 'Zend/Db/Adapter/Sqlsrv/Exception.php';
                 throw new Zend_Db_Adapter_Sqlsrv_Exception('FETCH_BOUND is not supported yet');
                 break;
             default:
                 #require_once 'Zend/Db/Adapter/Sqlsrv/Exception.php';
                 throw new Zend_Db_Adapter_Sqlsrv_Exception("Invalid fetch mode '$mode' specified");
                 break;
         }
     }

◆ setTransactionIsolationLevel()

setTransactionIsolationLevel ( $level = null )

Set the transaction isoltion level.

Parameters

integer | null $level A fetch mode from SQLSRV_TXN_*.

Returns: true

Exceptions

Zend_Db_Adapter_Sqlsrv_Exception

Definition at line 214 of file Sqlsrv.php.

     {
         $this->_connect();
         $sql = null;
 
         // Default transaction level in sql server
         if ($level === null)
         {
             $level = SQLSRV_TXN_READ_COMMITTED;
         }
 
         switch ($level) {
             case SQLSRV_TXN_READ_UNCOMMITTED:
                 $sql = "READ UNCOMMITTED";
                 break;
             case SQLSRV_TXN_READ_COMMITTED:
                 $sql = "READ COMMITTED";
                 break;
             case SQLSRV_TXN_REPEATABLE_READ:
                 $sql = "REPEATABLE READ";
                 break;
             case SQLSRV_TXN_SNAPSHOT:
                 $sql = "SNAPSHOT";
                 break;
             case SQLSRV_TXN_SERIALIZABLE:
                 $sql = "SERIALIZABLE";
                 break;
             default:
                 #require_once 'Zend/Db/Adapter/Sqlsrv/Exception.php';
                 throw new Zend_Db_Adapter_Sqlsrv_Exception("Invalid transaction isolation level mode '$level' specified");
         }
 
         if (!sqlsrv_query($this->_connection, "SET TRANSACTION ISOLATION LEVEL $sql;")) {
             #require_once 'Zend/Db/Adapter/Sqlsrv/Exception.php';
             throw new Zend_Db_Adapter_Sqlsrv_Exception("Transaction cannot be changed to '$level'");
         }
 
         return true;
     }

◆ supportsParameters()

supportsParameters ( $type )

Check if the adapter supports real SQL parameters.

Parameters

string $type 'positional' or 'named'

Returns: bool

Definition at line 653 of file Sqlsrv.php.

     {
         if ($type == 'positional') {
             return true;
         }
 
         // if its 'named' or anything else
         return false;
     }

Field Documentation

◆ $_config

$_config

protected

Initial value:

= array(
        'dbname'       => null,
        'username'     => null,
        'password'     => null,
    )

Definition at line 53 of file Sqlsrv.php.

◆ $_defaultStmtClass

$_defaultStmtClass = 'Zend_Db_Statement_Sqlsrv'

protected

Definition at line 105 of file Sqlsrv.php.

◆ $_lastInsertId

$_lastInsertId

protected

Definition at line 64 of file Sqlsrv.php.

◆ $_lastInsertSQL

$_lastInsertSQL = 'SELECT SCOPE_IDENTITY() as Current_Identity'

protected

Definition at line 71 of file Sqlsrv.php.

◆ $_numericDataTypes

$_numericDataTypes

protected

Initial value:

= array(
        Zend_Db::INT_TYPE    => Zend_Db::INT_TYPE,
        Zend_Db::BIGINT_TYPE => Zend_Db::BIGINT_TYPE,
        Zend_Db::FLOAT_TYPE  => Zend_Db::FLOAT_TYPE,
        'INT'                => Zend_Db::INT_TYPE,
        'SMALLINT'           => Zend_Db::INT_TYPE,
        'TINYINT'            => Zend_Db::INT_TYPE,
        'BIGINT'             => Zend_Db::BIGINT_TYPE,
        'DECIMAL'            => Zend_Db::FLOAT_TYPE,
        'FLOAT'              => Zend_Db::FLOAT_TYPE,
        'MONEY'              => Zend_Db::FLOAT_TYPE,
        'NUMERIC'            => Zend_Db::FLOAT_TYPE,
        'REAL'               => Zend_Db::FLOAT_TYPE,
        'SMALLMONEY'         => Zend_Db::FLOAT_TYPE,
    )

Definition at line 84 of file Sqlsrv.php.

The documentation for this class was generated from the following file:

vendor/magento/zendframework1/library/Zend/Db/Adapter/Sqlsrv.php

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Member Function Documentation

◆ _beginTransaction()

◆ _checkRequiredOptions()

◆ _commit()

◆ _connect()

◆ _quote()

◆ _rollBack()

◆ closeConnection()

◆ describeTable()

◆ getServerVersion()

◆ insert()

◆ isConnected()

◆ lastInsertId()

◆ limit()

◆ listTables()

◆ prepare()

◆ setFetchMode()

◆ setTransactionIsolationLevel()

◆ supportsParameters()

Field Documentation

◆ $_config

◆ $_defaultStmtClass

◆ $_lastInsertId

◆ $_lastInsertSQL

◆ $_numericDataTypes