--TEST-- Bind miscellaneous column types using default types --EXTENSIONS-- oci8 --SKIPIF-- true, 'timesten' => false); // test runs on these DBs require(__DIR__.'/skipif.inc'); ?> --FILE-- --EXPECT-- TEST86 insert all ORATYPE values TEST87 SELECT all values using DEFINEs ID is 86 CHAR_T is C CHAR_T10 is char10 VARCHAR2_T10 is varchar210 NUMBER_T is -123.456 NUMBER_T92 is 789.35 NUMBER_T6 is 123456 DATE_T is 29-MAR-10 TIMESTAMP_T is 29-MAR-10 01.09.15.000000 PM FLOAT_T is 12345678901234567890123456789012345679 BINARY_FLOAT_T is 1.23456784E+037 BINARY_DOUBLE_T is 1.2345678901234568E+037 DECIMAL_T is 86 INTEGER_T is 86 NCHAR_T is nchar10 NVARCHAR2_T10 is nvarchar2x VARCHAR_T10 is varchar TEST52 insert numbers array(1) { ["NUMBER_T92"]=> array(1) { [0]=> string(1) "3" } } TEST53 insert numbers array(1) { ["NUMBER_T92"]=> array(1) { [0]=> string(4) "8.67" } } TEST54 insert numbers array(1) { ["NUMBER_T"]=> array(1) { [0]=> string(4) "4.67" } } TEST55 insert numbers array(1) { ["NUMBER_T"]=> array(1) { [0]=> string(4) "7.67" } } TEST56 insert numbers array(1) { ["NUMBER_T"]=> array(1) { [0]=> string(5) "-5.67" } } TEST58 insert a VARCHAR2 array(1) { ["VARCHAR2_T10"]=> array(1) { [0]=> string(4) "Hood" } } TEST59 insert a VARCHAR2 array(1) { ["CHAR_T10"]=> array(1) { [0]=> string(10) "Hood " } } TEST60 insert a date array(1) { ["DATE_T"]=> array(1) { [0]=> string(9) "09-APR-10" } }