lobtest.out

derby database source code.good for you.

	Scale     : 0
	isCurrency: false
	isCaseSens: true
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = '103' : java.lang.String
	OUT = NULL
	OUT = NULL
	OUT = 'true' : java.lang.String
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
select col_4 from bit_table
	---- 1
	Column    : COL_4
	Type      : -2
	TypeName  : CHAR FOR BIT DATA
	ClassName : byte[]
	Label     : COL_4
	DisplaySz : 20
	Precision : 10
	Scale     : 0
	isCurrency: false
	isCaseSens: false
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
	OUT = NULL
select col_5 from bit_table
	---- 1
	Column    : COL_5
	Type      : -4
	TypeName  : LONG VARCHAR FOR BIT DATA
	ClassName : byte[]
	Label     : COL_5
	DisplaySz : 65400
	Precision : 32700
	Scale     : 0
	isCurrency: false
	isCaseSens: false
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
select col_6 from bit_table
	---- 1
	Column    : COL_6
	Type      : 2004
	TypeName  : BLOB
	ClassName : java.sql.Blob
	Label     : COL_6
	DisplaySz : 160
	Precision : 80
	Scale     : 0
	isCurrency: false
	isCaseSens: false
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = Object : java.sql.Blob
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = Object : java.sql.Blob
	OUT = NULL
select typecol from bit_table
	---- 1
	Column    : TYPECOL
	Type      : -2
	TypeName  : CHAR FOR BIT DATA
	ClassName : byte[]
	Label     : TYPECOL
	DisplaySz : 16
	Precision : 8
	Scale     : 0
	isCurrency: false
	isCaseSens: false
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = Object : byte[]
-----< columns CAST TO type: METADATA TESTS
select cast( col_0 as char (8) for bit data ) from bit_table
	ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
select cast( col_1 as char (8) for bit data ) from bit_table
	ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_2 as char (8) for bit data ) from bit_table
	ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_3 as char (8) for bit data ) from bit_table
	ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_4 as char (8) for bit data ) from bit_table
	---- 1
	Column    : 1
	Type      : -2
	TypeName  : CHAR FOR BIT DATA
	ClassName : byte[]
	Label     : 1
	DisplaySz : 16
	Precision : 8
	Scale     : 0
	isCurrency: false
	isCaseSens: false
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
	OUT = NULL
select cast( col_5 as char (8) for bit data ) from bit_table
	---- 1
	Column    : 1
	Type      : -2
	TypeName  : CHAR FOR BIT DATA
	ClassName : byte[]
	Label     : 1
	DisplaySz : 16
	Precision : 8
	Scale     : 0
	isCurrency: false
	isCaseSens: false
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
select cast( col_6 as char (8) for bit data ) from bit_table
	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
select cast( typecol as char (8) for bit data ) from bit_table
	---- 1
	Column    : 1
	Type      : -2
	TypeName  : CHAR FOR BIT DATA
	ClassName : byte[]
	Label     : 1
	DisplaySz : 16
	Precision : 8
	Scale     : 0
	isCurrency: false
	isCaseSens: false
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = Object : byte[]
-----< type CAST TO types: METADATA TESTS
select cast( typecol as int ) from bit_table
	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
select cast( typecol as char(10) ) from bit_table
	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
select cast( typecol as varchar(80) ) from bit_table
	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
select cast( typecol as long varchar ) from bit_table
	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
select cast( typecol as char(10) for bit data ) from bit_table
	---- 1
	Column    : 1
	Type      : -2
	TypeName  : CHAR FOR BIT DATA
	ClassName : byte[]
	Label     : 1
	DisplaySz : 20
	Precision : 10
	Scale     : 0
	isCurrency: false
	isCaseSens: false
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = Object : byte[]
select cast( typecol as long varchar for bit data ) from bit_table
	---- 1
	Column    : 1
	Type      : -4
	TypeName  : LONG VARCHAR FOR BIT DATA
	ClassName : byte[]
	Label     : 1
	DisplaySz : 65400
	Precision : 32700
	Scale     : 0
	isCurrency: false
	isCaseSens: false
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = Object : byte[]
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = Object : byte[]
select cast( typecol as blob(80) ) from bit_table
	---- 1
	Column    : 1
	Type      : 2004
	TypeName  : BLOB
	ClassName : java.sql.Blob
	Label     : 1
	DisplaySz : 160
	Precision : 80
	Scale     : 0
	isCurrency: false
	isCaseSens: false
	isDefWrite: false
	isWrite   : false
	isSearchab: true
	OUT = Object : java.sql.Blob
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = NULL
	OUT = Object : java.sql.Blob
select cast( typecol as char (8 ) for bit data ) from bit_table
	---- 1
	Column    : 1
	Type      : -2
	TypeName  : CHAR FOR BIT DATA
	ClassName : byte[]
	Label     : 1
	DisplaySz : 16
	Precision : 8
	Scale     : 0