Oct 26, 2010, 8:25 PM
In db table i have defined a column as varchar(max)...
when i fetch this column using perl DBI it is not returning any value..
query1 : select columna from table1
--> columna is varchar(max)
query1 didt return anything
where as columnb in same table which is varchar(8000), returns the value.
so i tried type casting on columna,
query2 : select cast(columna as varchar(8000)) as colA from table1
query2 : this worked.
but my data in this column is exceding 8000 chars...so i tried this,
query3 : select cast(columna as varchar(max)) as colA from table1
no error msg, no warning, it just returned nothing.
(This post was edited by sriharsha_12 on Oct 26, 2010, 8:26 PM)