Wouldn't that be a problem of your program? MySQL will sotre
anything and not care about what it is. You encrypt first, then
insert, next retrieve and decrypt.
Jason Whitlow schrieb am Mittwoch, 25. Juli 2001, 17:34:05:
I hope this is not to stupid.
I have looked at how to encrypt strings in
So sprach »Christian Grimm« am 2001-07-25 um 22:16:04 +0200 :
sa must be a 2-char long Salt-String...
Which is completely optional :)
sql,database,filter
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage:
I hope this is not to stupid.
I have looked at how to encrypt strings in my database. I know that you need
to use a blob
and I think I can figure out how to encrypt from a query or SELECT but how
do I
encrypt on the INSERT.
Thanks for your help
Jason
How about this:
---
INSERT INTO Table VALUES(Lamer_ID, SELECT ENCRYPT(you are
lame...!,sa));
---
uses the unix-crypt()-function, means, its a One-Way-Crypt!
sa must be a 2-char long
Sorry ---
How about this WITHOUT SELECT:
---
INSERT INTO Table VALUES(Lamer_ID, ENCRYPT(you are
lame...!,sa));
---
uses the unix-crypt()-function, means, its