Hi Chee

I encrypt data in my application but only data that needs to be, I think it is rare to have to encrypt everything and not a very good idea.
You still need keys and index's to sort data on whatever you store.

Anyway I don't ever store binary info in the database (you can with blobs) but I base64 encode the binary result so that it is in ascii form, as most of the data is <64 bytes.
I use the excellent Turbo power Lock box which is available for free on www.sourceforge.org

Good luck

Rgds

Peter

----- Original Message -----
From: chee hee
To: firebird-support@yahoogroups.com
Sent: Thursday, November 20, 2003 6:16 AM
Subject: [firebird-support] Crypting data


Hi All,

If someone can access to database file and have password, he/she can view data inside.

I want to build an application which has embedded an encryption key and all data stored in firebird db is encrypted using this key.
So, anymore has access to the db file will only see junk.

Has anyone done so, like building an encryption layer between the app and the db?

Issue concern:
1) Performance issue as all data transfer need encryption and decryption.
2) Data type - encrypted currency might look like *yw>9)q01. How to store them? All varchar fields?

Thanks.

cm


---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger

[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]