using crystal reports with postgresql

[lewie]

I have a Crystal Reports(8.5) report which uses a Postgresql(7.1) DB. I have a large field lngvarchar in my Postgresql db which is being cut to 254 chars in Crystal(string fld).
I was wondering if anyone has any ideas how I could get the other info??

 

[rycamor]

Traditionally, varchar columns in other DBMS's were restricted to 255 characters, so I suppose Crystal Reports arbitrarily makes that assumption with that type. Perhaps if you convert the field to type "text" it will work fine.

-------------------------------------------

My PostgreSQL FAQ --

http://brainscraps.com/faq/pg_my.html