Re: [SQL] How to find entries missing in 2nd table?

I have received good performance with the following:   select c.controller    from control c    left outer join datapack d on d.controller_id = c.controller_id  where d.controller_id is null   Nate Teller   -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL P

[SQL] Storing encrypted data?

Hi, Does anyone have experience with storing encrypted data into pgSQL? I have a pgSQL database which uses UTF8 encoding. I am encrypting plain text in my (GUI) application and sending it to a field (with data type 'text') in my database. I get an error back saying "invalid byte sequence fo

Re: [SQL] Storing encrypted data?

On Mon, Jul 17, 2006 at 09:11:12AM +0800, John Tregea wrote: > Does anyone have experience with storing encrypted data into pgSQL? I > have a pgSQL database which uses UTF8 encoding. I am encrypting plain > text in my (GUI) application and sending it to a field (with data type > 'text') in my da

Re: [SQL] Storing encrypted data?

Hi Michael, Thanks for your advice. I was looking at the bytea data type in the PostgreSQL book I bought (Korry and Susan Douglas, second edition). I was concerned that if I have to escape certain characters like the single quote or the backslash, how do I guarantee that the escaped version d