Re: [SQL] ERROR: unterminated quoted string... help

On Tue, 2005-05-17 at 13:15, Postgres Admin wrote: > Hi > > I'm trying to insert encrypted data into the database and I'm noticing > error dealing with quotes. Below is the error print out... > > suggestions and/or at least point me in the direction to find a solution, > > Thanks, > J > > >

Re: [SQL] ERROR: unterminated quoted string... help

Scott Marlowe wrote: Use a bytea field and use pg_escape_bytea() to prepare the data for insertion. Thanks Scott, I will try it now. J ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-noma

[SQL] ERROR: unterminated quoted string... help

Hi I'm trying to insert encrypted data into the database and I'm noticing error dealing with quotes. Below is the error print out... suggestions and/or at least point me in the direction to find a solution, Thanks, J INSERT INTO sample.users (user_name, first_name) VALUES ('jokers', '=ïµiF!¶6