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

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

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



sriharsha_12
Novice

Oct 26, 2010, 8:25 PM


Views: 4732
PERL + SQL VARCHAR(MAX)

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)


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