| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Postgres Admin <postgres(at)productivitymedia(dot)com> |
| Cc: | pgsql-php(at)postgresql(dot)org, Sql-Postgre <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: ERROR: unterminated quoted string... help |
| Date: | 2005-05-17 18:27:12 |
| Message-ID: | 1116354432.22291.136.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php pgsql-sql |
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
>
>
>
> INSERT INTO sample.users (user_name, first_name) VALUES
> ('jokers', '=ïµiF!¶6(ÖŸã¾óˆÌ‘'-Iw‰iDÖiJÐÿ† %')
>
> Warning: pg_query() [function.pg-query]: Query failed: ERROR:
> unterminated quoted string at or near "'=ïµi" at character 68 in
> /usr/local/apache2/htdocs/php/5/Theirry_DB.php on line 162
Use a bytea field and use pg_escape_bytea() to prepare the data for
insertion.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Postgres Admin | 2005-05-17 18:33:03 | Re: [SQL] ERROR: unterminated quoted string... help |
| Previous Message | Postgres Admin | 2005-05-17 18:15:53 | ERROR: unterminated quoted string... help |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Postgres Admin | 2005-05-17 18:33:03 | Re: [SQL] ERROR: unterminated quoted string... help |
| Previous Message | Jay Parker | 2005-05-17 18:20:09 | Re: triggering an external action |