
sriharsha_12
Novice
Oct 26, 2010, 8:25 PM
Post #1 of 9
(6807 views)
|
PERL + SQL VARCHAR(MAX)
|
Can't Post
|
|
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. Any Solution?
(This post was edited by sriharsha_12 on Oct 26, 2010, 8:26 PM)
|