ADODB2_mssql Klassenreferenz

Klassendiagramm für ADODB2_mssql:

Zusammengehörigkeiten von ADODB2_mssql:

Öffentliche Methoden
	MetaType ($t, $len=-1, $fieldobj=false)
	ActualType ($meta)
	AddColumnSQL ($tabname, $flds)
	DropColumnSQL ($tabname, $flds)
	_CreateSuffix ($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned)
	_IndexSQL ($idxname, $tabname, $flds, $idxoptions)
	_GetSize ($ftype, $ty, $fsize, $fprec)
Datenfelder
	$databaseType = 'mssql'
	$dropIndex = 'DROP INDEX %2$s.%1$s'
	$renameTable = "EXEC sp_rename '%s','%s'"
	$renameColumn = "EXEC sp_rename '%s.%s','%s'"
	$typeX = 'TEXT'
	$typeXL = 'TEXT'

---

Ausführliche Beschreibung

Definiert in Zeile 44 der Datei datadict-mssql.inc.php.

---

Dokumentation der Elementfunktionen

_GetSize	(	$	ftype,
		$	ty,
		$	fsize,
		$	fprec
	)

GENERATE THE SIZE PART OF THE DATATYPE $ftype is the actual type $ty is the type defined originally in the DDL

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 270 der Datei datadict-mssql.inc.php.

        {
                switch ($ftype) {
                case 'INT':
                case 'SMALLINT':
                case 'TINYINT':
                case 'BIGINT':
                        return $ftype;
                }
        if ($ty == 'T') return $ftype;
        return parent::_GetSize($ftype, $ty, $fsize, $fprec);    

        }

ActualType

(

$

meta

)

Returns the actual type given a character code.

C: varchar X: CLOB (character large object) or largest varchar size if CLOB is not supported C2: Multibyte varchar X2: Multibyte CLOB

B: BLOB (binary large object)

D: Date T: Date-time L: Integer field suitable for storing booleans (0 or 1) I: Integer F: Floating point number N: Numeric or decimal number

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 79 der Datei datadict-mssql.inc.php.

        {
                switch(strtoupper($meta)) {

                case 'C': return 'VARCHAR';
                case 'XL': return (isset($this)) ? $this->typeXL : 'TEXT';
                case 'X': return (isset($this)) ? $this->typeX : 'TEXT'; ## could be varchar(8000), but we want compat with oracle
                case 'C2': return 'NVARCHAR';
                case 'X2': return 'NTEXT';
                
                case 'B': return 'IMAGE';
                        
                case 'D': return 'DATETIME';
                
                case 'TS':
                case 'T': return 'DATETIME';
                case 'L': return 'BIT';
                
                case 'R':               
                case 'I': return 'INT'; 
                case 'I1': return 'TINYINT';
                case 'I2': return 'SMALLINT';
                case 'I4': return 'INT';
                case 'I8': return 'BIGINT';
                
                case 'F': return 'REAL';
                case 'N': return 'NUMERIC';
                default:
                        return $meta;
                }
        }

---

Die Dokumentation für diese Klasse wurde erzeugt aufgrund der Datei:

• datadict/datadict-mssql.inc.php