Re: [SQL] Fwd: How to encrypt a column

2005-08-12 Thread Bruno Wolff III
Please keep replies posted to the list unless you have a specific reason not to. On Fri, Aug 12, 2005 at 14:56:54 -0700, Jeff Lu <[EMAIL PROTECTED]> wrote: > I can't see why it's returning (null). > > sprintf(query_string, "INSERT INTO mytable values('%s', '%s')", key, , > encrypt('hello w

Re: [SQL] Fwd: How to encrypt a column

2005-08-11 Thread Bruno Wolff III
On Thu, Aug 11, 2005 at 13:50:45 -0700, Owen Jacobson <[EMAIL PROTECTED]> wrote: > Jeff Lu wrote: > > > Another question is can the encrypted column be of type "text" ? > > Can't see any reason why not, so long as the encrypted data is represented > as text. There can't be any 0 bytes in the e

Re: [SQL] Fwd: How to encrypt a column

2005-08-11 Thread Owen Jacobson
Jeff Lu wrote: > Owen Jacobson <[EMAIL PROTECTED]> wrote: >> Jeff Lu wrote: >> >>> Hi, >>> >>> I'm interested in encrypting an column in table. Are there any >>> example using "C" to create the encrypted column, inserting and >>> retreiving data to/from it? >>> >>> the table is: >>> CREATE TABLE my

Re: [SQL] Fwd: How to encrypt a column

2005-08-11 Thread Jeff Lu
I do get a couple of warnings at compile time: intrasend.c:496:37: warning: multi-character character constantintrasend.c:496:44: warning: multi-character character constantintrasend.c:517:84: warning: character constant too long for its type   Here's what is in the variable "data" = "0018`0018`64

Re: [SQL] Fwd: How to encrypt a column

2005-08-11 Thread Hélder M . Vieira
I'm interested in encrypting an column in table. Are there any example using "C" to create the encrypted column, inserting and retreiving data to/from it? the table is: CREATE TABLE mytable ( id SERIAL PRIMARY KEY, crypted_content BYTEA ); I'm getting (null) in the field with the follow

Re: [SQL] Fwd: How to encrypt a column

2005-08-11 Thread Owen Jacobson
Jeff Lu wrote: > Hi, > > I'm interested in encrypting an column in table. Are there any > example using "C" to create the encrypted column, inserting and > retreiving data to/from it? > > the table is: > CREATE TABLE mytable ( > id SERIAL PRIMARY KEY, > crypted_content BYTEA > ); > > I

[SQL] Fwd: How to encrypt a column

2005-08-11 Thread Jeff Lu
Hi,   I'm interested in encrypting an column in table.  Are there any example using "C" to create the encrypted column, inserting and retreiving data  to/from it?   the table is: CREATE TABLE mytable (  id SERIAL PRIMARY KEY,  crypted_content BYTEA ); I'm getting (null) in the field with t