Re: Storing encrypted strings in a password column

Thanks Andy. At least I have something to go on here. Our senior DBA showed me that a VARCHAR2 can cope with binary characters. One query he did was:

UPDATE <table> SET PASSWORD = CHR(0)||CHR(255) WHERE <criteria>

Sure enough, it stored it. Although there are likely some characters it wouldn't work with.

I think a change of column type is required here.

Thanks.

JL Received on Fri Sep 13 2002 - 20:05:38 CDT