PHP: ora_columntype

Description

string ora_columntype ( resource cursor, int column )

Returns the Oracle data type name of the field/column column on the cursor cursor. Column 0 is the first column. The returned type will be one of the following:

"VARCHAR2"

"VARCHAR"

"CHAR"

"NUMBER"

"LONG"

"LONG RAW"

"ROWID"

"DATE"

"CURSOR"

ora_columntype

kk at shonline dot de
05-Aug-1998 08:32


And the mapping between SQL types (see $ORACLE_HOME/rdbms/demo/ocidfn.h) and return strings is as follows:<p>





SQLT_CHR (character string) becomes VARCHAR2


SQLT_VCS (variable character string) becomes VARCHAR


SQLT_AVC (Ansi var char) becomes VARCHAR


SQLT_STR (zero terminated string) becomes CHAR


SQLT_AFC (Ansi fixed char) becomes CHAR


SQLT_NUM (oracle numeric) becomes NUMBER


SQLT_INT (integer) becomes NUMBER


SQLT_FLT (floating point number) becomes NUMBER


SQLT_UIN becomes NUMBER


SQLT_LNG (long) becomes LONG


SQLT_LBI (long binary) becomes LONG RAW


SQLT_RID (rowid) becomes ROWID


SQLT_DAT (date in oracle format) becomes DATE


SQLT_CUR (cursor) becomes CURSOR





All other types (and there are many of them) become UNKNOWN