Re: HELP! Insertin HEX into a table

In article <MARY.95May11084439_at_shark>, Mary E. Hunt (mary_at_mitra.com) writes:
>
>I want to insert hexadecimal values (ie 0x0010, 0x0050) into a column.
>How should I define the column? Should it be NUMBER? I know there is
>a hextoraw and rawtohex function but I don't know how I should use
>them to insert these values.
>
>Thanks in advance for your help.
>
>Mary
Hi Mary,

I am not familiar with any conversion function to and from HEX.

As for storing as a numeric value, it depends on what you are using the Hex values for, but it seems to me to be a rather laborious process conevrting it to and from Hex values, just to be able to store it as NUMBER value.

Why not store it in a VARCHAR2 (CHAR if you are using V6) column? The Alpha components (A-F) would prevent you form storing as NUMBER without conversion.

Regards,
Alex Long

--
                          ,     \    /      ,
                         / \    )\__/(     / \   
                        /   \  (_\  /_)   /   \                
 ______________________/_____\__\_at_  @/___/_____\________________ 
|paladin.along.dialix.oz.au 					|
|Alex Long 		   					|		
|Adelaide, South Australia 					|
|_______________________________________________________________|
|Weep not for little Leonie,                   			|
|Abducted by a French Marquis!               			|
|Though loss of honour was a wrench,           			|
|Just think how it's improved her French.         Harry Graham. |
+_______________________________________________________________+
                   |    /\ /      \\       \ /\    |             
                   |  /   V        ))       V   \  |
                   |/     `       //        '     \|
                   `              V                '
                   
_