CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: Advanced: PERL + SQL VARCHAR(MAX): Edit Log


Oct 26, 2010, 8:25 PM

Views: 7475

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 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)

Edit Log:
Post edited by sriharsha_12 (Novice) on Oct 26, 2010, 8:26 PM

Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives