Board index » delphi » Using varchar2 > 255 in Oracle

Charlie McKeegan

Delphi Developer
Mon, 29 Dec 2003 19:12:51 GMT

Using varchar2 > 255 in Oracle

Hi,

I've a few varchar2 fields in the database that are  upto 2000 in size.
However when I try to access these via the BDE it always treats them as a
Blob... if I do the same in MSSQL it treats them as TStringFields. Since the
app has to run against both Oracle & MSSQL this is a major problem.

No sugestions of don't use the BDE please since it isn't an option.

Many thanks

// charlie

 
Martyn Spence

Delphi Developer
Mon, 29 Dec 2003 21:49:29 GMT

Re:Using varchar2 > 255 in Oracle


I think the problem may be because fields that are this size are viewed by
the BDE/Oracle link as a long data type, therefore it says that it is a
BLOB.  Only a suggestion, but why not try using SUBSTR to shorten the field
(if possible), or even SUBSTR on the full field length.  This may be enough
to kid the BDE into thinking that it is a string field after all.

HTH.

Martyn

Quote
"Charlie McKeegan" <charlie.mckee...@engn.com> wrote in message

news:3b4d8602_2@dnews...
Quote
> Hi,

> I've a few varchar2 fields in the database that are  upto 2000 in size.
> However when I try to access these via the BDE it always treats them as a
> Blob... if I do the same in MSSQL it treats them as TStringFields. Since
the
> app has to run against both Oracle & MSSQL this is a major problem.

> No sugestions of don't use the BDE please since it isn't an option.

> Many thanks

> // charlie

John Pierc

Delphi Developer
Mon, 29 Dec 2003 23:49:03 GMT

Re:Using varchar2 > 255 in Oracle


This is the way the BDE/SQlLinks views Oracle VARCHAR2 fields > 255
(254?), and I have not found a way around it, other than the way you
won't take.

John PIerce

Other Threads

1. Oracle Varchar2 Field > 255 chars in Delphi

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

3. VARCHAR2 > 255

4. >255 text to Varchar2(2000)

5. Oracle varchar2 fields longer than 255

6. network broadcast to 255.255.255.255 or x.x.x.255 doesn't work

7. Oracle stored procedure problem (strings > 255)

8. Help - Oracle RAW(>255) for image data

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

10. Oracle VARCHAR2 > 255 and very long table length