hi list/henry-- i set my colubm to be varchar for bit data, but my encrypted data is still getting munged. or rather, when i grab it later, it doesn't look right. but i am grabbing data from this column via ODBC. is it possible that ODBC is to blame? i am using unixODBC on linux, which uses the db2cli library. the data gets inserted via unixODBC as well. is there something special i need to do when i do the insert?
here's an example: in my script, if i print out the encrypted string, it looks like this (sorry, this may get destroyed in email, i don't know): D>CP6k ��&aD when i grab from the db, it looks like this (totally different): @��hT using my little database browser thingy for windoze, the field looks like this: x'014006F690685417' sorry to bug you all with this, but i am a stranger in a strange land... thanks steve > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Henry J. Cobb > Sent: Tuesday, January 14, 2003 5:03 PM > To: [EMAIL PROTECTED] > Subject: Re: [DB2EUG] storing encrypted data > > > > i am storing credit card numbers in my database. i am > using the 3DES > > algorithm. i noticed that if i print out the encrypted > string from my > > application (prior to insertion), it comes out looking rather > > different than what i end up seeing in db2 after i insert it. the > > field in db2 is a varchar field. will the characters i can > store in a > > varchar field be affected by my locale settings? what data type > > should i use to store this kind of thing? > > c.f. FOR BIT DATA > > -HJC > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > *** For more information, check http://www.db2eug.uni.cc > - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
