OraFAQ Forum: Server Administration » Problem with RAW datatype

Home » RDBMS Server » Server Administration » Problem with RAW datatype (10.2.0.5 standard edition Micsoft windows 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with RAW datatype [message #581212]

Wed, 03 April 2013 09:28

AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai

Member

Hi,

Please advice on RAW datatype in oracle,any problems we will face using this datatype,Reason is we have column which stores session id in RAW datatype using sys_guid,Please advice any drawbacks in using this datatype.

Regards,
Anil

Report message to a moderator

Re: Problem with RAW datatype [message #581213 is a reply to message #581212]

Wed, 03 April 2013 09:34

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't see none but it depends on what thing is a drawback for you.

Regards
Michel

Report message to a moderator

Re: Problem with RAW datatype [message #581214 is a reply to message #581212]

Wed, 03 April 2013 09:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://docs.oracle.com/cd/B28359_01/server.111/b28286/functions175.htm#SQLRF06120

works fine & lasts a long time.

Report message to a moderator

Re: Problem with RAW datatype [message #581215 is a reply to message #581213]

Wed, 03 April 2013 09:41

AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai

Member

Hi,

Draw back in sense unlike like varchar raw consider data as binary, I have doubt

1)if we can export/import the raw datatype to different charactertset?
2)Can we insert number in raw?
3)Also please advice difference between in using varchar2 and raw datatype.

Regards,
Anil

Report message to a moderator

Re: Problem with RAW datatype [message #581217 is a reply to message #581215]

Wed, 03 April 2013 09:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Draw back in sense unlike like varchar raw consider data as binary
DATE datatype is also binary. Do you have a problem using DATE datatypes?

>1)if we can export/import the raw datatype to different charactertset?
I give up. Can you?

>2)Can we insert number in raw?
I give up. Can you?

>3)Also please advice difference between in using varchar2 and raw datatype.
Consider to actually Read The Fine Manual yourself.
http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements001.htm#sthref204

[Updated on: Wed, 03 April 2013 09:53]

Report message to a moderator

Re: Problem with RAW datatype [message #581224 is a reply to message #581215]

Wed, 03 April 2013 10:52

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Draw back in sense unlike like varchar raw consider data as binary.

Of course this is its purpose.
Why aren't you concerned that varchar unlike number are consider as string?

1) character set is meaningless for binary data
2) If you convert it to a raw
3) Irrelevant and meaningless question.
Please advice difference between in using varchar2 and number datatype.

Regards
Michel

[Updated on: Wed, 03 April 2013 10:53]

Report message to a moderator

Previous Topic:	ORA-03001: unimplemented feature
Next Topic:	Delayed Logon

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 01:19:17 CST 2025