Home » RDBMS Server » Server Administration » Problem with RAW datatype (10.2.0.5 standard edition Micsoft windows 2008)
Problem with RAW datatype [message #581212] Wed, 03 April 2013 09:28 Go to next message
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
Re: Problem with RAW datatype [message #581213 is a reply to message #581212] Wed, 03 April 2013 09:34 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't see none but it depends on what thing is a drawback for you.


Regards
Michel
Re: Problem with RAW datatype [message #581214 is a reply to message #581212] Wed, 03 April 2013 09:37 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
http://docs.oracle.com/cd/B28359_01/server.111/b28286/functions175.htm#SQLRF06120

works fine & lasts a long time.
Re: Problem with RAW datatype [message #581215 is a reply to message #581213] Wed, 03 April 2013 09:41 Go to previous messageGo to next message
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
Re: Problem with RAW datatype [message #581217 is a reply to message #581215] Wed, 03 April 2013 09:48 Go to previous messageGo to next message
BlackSwan
Messages: 22792
Registered: January 2009
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 Go to previous message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Sun Sep 21 05:30:51 CDT 2014

Total time taken to generate the page: 0.11322 seconds