jordanwb Posted December 22, 2008 Share Posted December 22, 2008 I need to store SIN numbers in a database. I've found a couple of 2-way algorhythms but they don't return hexadecimal strings. Anyone know of any good algorhythms? Quote Link to comment Share on other sites More sharing options...
Mark Baker Posted December 22, 2008 Share Posted December 22, 2008 I need to store SIN numbers in a database. I've found a couple of 2-way algorhythms but they don't return hexadecimal strings. Anyone know of any good algorhythms? Plenty, and they'll all return binary data. You'll need to convert it from binary to text if you want to store it in a VARCHAR2 in a database, or use a CLOB to store it as a binary. The base64_encode() function can be used to convert binary to text Quote Link to comment Share on other sites More sharing options...
jordanwb Posted December 22, 2008 Author Share Posted December 22, 2008 Good idea. Quote Link to comment Share on other sites More sharing options...
jordanwb Posted December 22, 2008 Author Share Posted December 22, 2008 Do you know if base64_encode will ever return quotes? It seems it does not. Quote Link to comment Share on other sites More sharing options...
Mark Baker Posted December 22, 2008 Share Posted December 22, 2008 Do you know if base64_encode will ever return quotes? The only characters used for base64 encoding are: ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/ Quote Link to comment Share on other sites More sharing options...
jordanwb Posted December 22, 2008 Author Share Posted December 22, 2008 The only characters used for base64 encoding are: ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/ Cool, thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.