We use encryption on various tables like wages etc. All the fields are
varchars and we use a simple encryption routine which only produces
printable characters. The ecryption/decryption is done on the client side
in places like OnGetText OnSetText for db enabled components or by calling
subroutines. During development we put an decryption udf in the database
and use it to create decrypted views so we can look at the raw data.

Regards
Paul

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of Ed Dressel
> Sent: 11 October 2007 15:18
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Encryption
>
> I used FB embedded and I have a potential client that
> requires the data in the database to be encrypted.
>
> Any suggestions on how to do this?
>
> Thanks you,
> Edward Dressel
>
>
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
> Yahoo! Groups Links
>
>
>