[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 807
  • Last Modified:

Binary type in Sybase and Raw type in Oracle

hello experts,
I am wondering if the use of these two types are the same in Sybase 12.x and Oracle 10g

Say sybase would work if we do
insert into aSybaseTable (binaryType) values(0x80abcd)

but if we do that in oracle for a raw type say
insert into anOracleTable(rawType) values(80abcd; (or replace  80abcd with 0x80abcd)
then oracle complains: incosistent data type: expected BINARY got NUMBER

I guess what I am looking for is
1) what is the equivalent type of Sybase binary type in Oracle?
And
2) How would we insert a value into Oracle raw field?

Thanks,
Do
0
dttai
Asked:
dttai
2 Solutions
 
bretCommented:
Your question seems to be more about Oracle than Sybase ASE, so perhaps you should have asked your question in the Oracle group instead.

Just as a guess, perhaps Oracle wants the value in quotes?
0
 
dttaiAuthor Commented:
Dear Admin,
Could you please move my question to Oracle section as suggested by bret??
Thank you,
Do
0
 
grant300Commented:
Try the Oracle function HEXTORAW.  It converts your hex value to a binary representation.

Bill
0
 
vn77Commented:
1) Oracle Raw is equivalent to Sybase binary
vn
0
 
dttaiAuthor Commented:
I close this question, and move it to oracle
thanks everyone,
Do
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now