Title: RE: Inserting raw ascii into a varchar2 field
Thanks. My error was trying to code hex in the chr(..) function to retrieve ascii, when it should be decimal to ascii.
chr(12) = FF (form feed) in ascii
chr(0D) = invalid construct because it's hex
Linda
-Original Me
Checkout UTL_RAW.CAST_TO_RAW to convert varchar2 to
raw datatypes
hth
connor
--- "Hagedorn, Linda" <[EMAIL PROTECTED]> wrote: >
Hello,
>
> Does anyone have an example of how to insert raw
> ascii into a varchar2
> field?
>
> For example,
> CREATE TABLE LH_test
> ( col1 varchar2(10),
>
I think the only sure non-printable characters are those of less than 32, on
or above 32 and they may well be printable depending on the character set.
I'm not sure what you're looking for example wise as it should just be a
case of using chr(asciicode) to do the insert.
If you have more than 255
Title: Inserting raw ascii into a varchar2 field
Hello,
Does anyone have an example of how to insert raw ascii into a varchar2 field?
For example,
CREATE TABLE LH_test
( col1 varchar2(10),
col2 varchar2(10),
col3 varchar2(10) )
PCTFREE 0 PCTUSED 80 INITRANS 1 MAXTRANS 255
