255 chars)

ste...@retailanalytics.com (Steven D'Abrosca)

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Oracle 8.0.4 - Reading/Posting Varchar2(>255 chars)

Delphi CS 4 SP3 & BDE 5.01

I use a query to write a varchar2 field that is 1000 chars, and it
works. When I read it with a select statement, I get an empty result
set.

If the field is 255 chars or less, all is fine.

Suggestions?

thanks

steve dabrosca

PS I haven't tested with lengths between 255 and 1000.

Eric

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Oracle 8.0.4 - Reading/Posting Varchar2(>255 chars)

Hi,

I think Delphi handles this as a TMemo Field then You need a TDBMemo to
display it.

Quote

Steven D'Abrosca wrote in message <36e6a92a.169593...@forums.inprise.com>...
>Delphi CS 4 SP3 & BDE 5.01

>I use a query to write a varchar2 field that is 1000 chars, and it
>works. When I read it with a select statement, I get an empty result
>set.

>If the field is 255 chars or less, all is fine.

>Suggestions?

>thanks

>steve dabrosca

>PS I haven't tested with lengths between 255 and 1000.

Other Threads

1. Oracle Varchar2 Field > 255 chars in Delphi

2. Using varchar2 > 255 in Oracle

3. Q: Reading > 255 char

4. Can't read char fields having chars greater than 255

5. VARCHAR2 > 255

6. >255 text to Varchar2(2000)

7. Oracle varchar2 fields longer than 255

8. Q: Oracle 8, TMemoFields, VARCHAR2 field > 255 chars

9. String manipulation > 255 chars

10. Text entry > 255 chars