Conversion from number to raw
724687Feb 25 2011 — edited Feb 25 2011We have an existing database where primary keys are numbers. We have to consolidate some of the tables this database with a new database where the primary keys are RAW's. How can we convert the numbers to raws (which "function" can we use) so we kan keep the values of our old primary keys, so we don't have to change the keys in all the other tables in the old database? So in fact, when the primary key is '12345', we want to see '12345' in the raw column, not the raw representation of '12345' (which is C302182E). We are aware that we have to use the same "function" for further operations on these keys, and this issue will be evaluated later.
So first we want to see if it is possible to begin with, to have the same value in the RAW column.