4 V5.18 3 Sep 2012 (c) 2000-2012 John Lim (jlim#natsoft.com). All rights reserved.
5 Released under both BSD license and Lesser GPL library license.
6 Whenever there is any discrepancy between the two licenses,
7 the BSD license will take precedence.
9 Set tabs to 4 for best viewing.
13 // security - hide paths
14 if (!defined('ADODB_DIR')) die();
16 class ADODB2_generic extends ADODB_DataDict {
18 var $databaseType = 'generic';
19 var $seqField = false;
22 function ActualType($meta)
25 case 'C': return 'VARCHAR';
27 case 'X': return 'VARCHAR(250)';
29 case 'C2': return 'VARCHAR';
30 case 'X2': return 'VARCHAR(250)';
32 case 'B': return 'VARCHAR';
34 case 'D': return 'DATE';
36 case 'T': return 'DATE';
38 case 'L': return 'DECIMAL(1)';
39 case 'I': return 'DECIMAL(10)';
40 case 'I1': return 'DECIMAL(3)';
41 case 'I2': return 'DECIMAL(5)';
42 case 'I4': return 'DECIMAL(10)';
43 case 'I8': return 'DECIMAL(20)';
45 case 'F': return 'DECIMAL(32,8)';
46 case 'N': return 'DECIMAL';
52 function AlterColumnSQL($tabname, $flds)
54 if ($this->debug) ADOConnection::outp("AlterColumnSQL not supported");
59 function DropColumnSQL($tabname, $flds)
61 if ($this->debug) ADOConnection::outp("DropColumnSQL not supported");
69 function ActualType($meta)
72 case 'C': return 'VARCHAR';
73 case 'X': return 'VARCHAR';
75 case 'C2': return 'VARCHAR'; // up to 32K
76 case 'X2': return 'VARCHAR';
78 case 'B': return 'BLOB';
80 case 'D': return 'DATE';
81 case 'T': return 'TIMESTAMP';
83 case 'L': return 'SMALLINT';
84 case 'I': return 'INTEGER';
85 case 'I1': return 'SMALLINT';
86 case 'I2': return 'SMALLINT';
87 case 'I4': return 'INTEGER';
88 case 'I8': return 'BIGINT';
90 case 'F': return 'DOUBLE';
91 case 'N': return 'DECIMAL';
98 function ActualType($meta)
101 case 'C': return 'VARCHAR';// 255
102 case 'X': return 'TEXT';
104 case 'C2': return 'NVARCHAR';
105 case 'X2': return 'TEXT';
107 case 'B': return 'BLOB';
109 case 'D': return 'DATE';
110 case 'T': return 'DATETIME';
112 case 'L': return 'SMALLINT';
113 case 'I': return 'INTEGER';
114 case 'I1': return 'SMALLINT';
115 case 'I2': return 'SMALLINT';
116 case 'I4': return 'INTEGER';
117 case 'I8': return 'DECIMAL(20)';
119 case 'F': return 'FLOAT';
120 case 'N': return 'DECIMAL';