Re: My Binary Experience

Scott Ferrett wrote:
>
> In article <33A05D73.663E_at_baps.com>, Werner wrote:
> > I was using an ADD, and it did not work - this is why I had to resort
> > to using my own SQL.
> > I you try to add the string 'Scott<0>Ferret' it will NEVER work.
> > You will always add 'Scott'...
>
> This depends on the backend data type. If you use VARCHAR2, then you
> will get Scott as VARCHAR2 does not allow non-printable characters. To
> have binary data you need to use LONG or RAW data types. Using Oracle
> Connect I was able to store binary data into these data types.
>
> SuRF Down Under
> (TopSpeed R&D)

You say VARCHAR2 does not allow non-printable character, this is simply not true. You can insert any type of character into a varchar2, if you load SQL*Plus and do a
" insert into table1
 (field1)
 values
('scott'||chr(0)||'Ferret');"
it will work fine, and what's more you can select * from tab1 without the problems that LONG RAW gives you.
I'm sure you can do it from within Clarion via the ADD function for ODBC or Oracle COnnect, I must just find out how... Received on Thu Jun 19 1997 - 00:00:00 CDT