|
Adodb Dokumentation
V5.14 8 Sept 2011
|


Öffentliche Methoden | |
| MetaType ($t, $len=-1, $fieldobj=false) | |
| ActualType ($meta) | |
| _CreateSuffix ($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned) | |
| _IndexSQL ($idxname, $tabname, $flds, $idxoptions) | |
Datenfelder | |
| $databaseType = 'mysql' | |
| $alterCol = ' MODIFY COLUMN' | |
| $alterTableAddIndex = true | |
| $dropTable = 'DROP TABLE IF EXISTS %s' | |
| $dropIndex = 'DROP INDEX %s ON %s' | |
| $renameColumn = 'ALTER TABLE %s CHANGE COLUMN %s %s %s' | |
Definiert in Zeile 16 der Datei datadict-mysql.inc.php.
| 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-mysql.inc.php.
{
switch(strtoupper($meta)) {
case 'C': return 'VARCHAR';
case 'XL':return 'LONGTEXT';
case 'X': return 'TEXT';
case 'C2': return 'VARCHAR';
case 'X2': return 'LONGTEXT';
case 'B': return 'LONGBLOB';
case 'D': return 'DATE';
case 'TS':
case 'T': return 'DATETIME';
case 'L': return 'TINYINT';
case 'R':
case 'I4':
case 'I': return 'INTEGER';
case 'I1': return 'TINYINT';
case 'I2': return 'SMALLINT';
case 'I8': return 'BIGINT';
case 'F': return 'DOUBLE';
case 'N': return 'NUMERIC';
default:
return $meta;
}
}