ERROR: unterminated quoted string... help

Hi

I'm trying to insert encrypted data into the database and I'm noticing=20
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=20
('jokers', '=ïµiF=17!=B66(֟㍾óˆÌ=91'-I w=89=
iDÖiJÐÿ=86 %')

Warning: pg_query() [function.pg-query]: Query failed: ERROR:=20
unterminated quoted string at or near "'=ïµi" at character 68 in=
=20
/usr/local/apache2/htdocs/php/5/Theirry_DB.php on line 162

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: ERROR: unterminated quoted string... help

On Tue, 2005-05-17 at 13:15, Postgres Admin wrote:
> Hi
>=20
> I'm trying to insert encrypted data into the database and I'm noticing=20
> error dealing with quotes. Below is the error print out...
>=20
> suggestions and/or at least point me in the direction to find a solution,
>=20
> Thanks,
> J
>=20
>=20
>=20
> INSERT INTO sample.users (user_name, first_name) VALUES=20
> ('jokers', '=ïµiF=17!¶6(ÖŸã¾=C3 =
³ˆÌ‘'-Iw‰iDÖiJÐ= C3¿â€  =
%')
>=20
> Warning: pg_query() [function.pg-query]: Query failed: ERROR:=20
> unterminated quoted string at or near "'=ïµi" at character=
68 in=20
> /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.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: 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-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: ERROR: unterminated quoted string... help

On 2005-05-17 14:15:53 -0400 (Tue, May), Postgres Admin wrote:
> Hi
>=20
> I'm trying to insert encrypted data into the database and I'm noticing=20
> error dealing with quotes. Below is the error print out...
>=20
> suggestions and/or at least point me in the direction to find a solution,
>=20
> Thanks,
> J
>=20
> INSERT INTO sample.users (user_name, first_name) VALUES=20
> ('jokers', '=3D??=06iF=17!?6(Ö????ó?=08??'-Iw?iDÖiJ??? %')
>=20
> Warning: pg_query() [function.pg-query]: Query failed: ERROR:=20
> unterminated quoted string at or near "'=3D??=06i" at character 68 in=20
> /usr/local/apache2/htdocs/php/5/Theirry_DB.php on line 162

You should pass the encrypted data thru pg_escape_string() function.
You surely should do it with almost EVERY string that you put as an
argument in a query, especially if it comes from 'outside'.

$query =3D "INSERT INTO .... ('jokers','" . pg_escape_string($encrypted) .=
"');" ;

--
bashian roulette:=20
$ ((RANDOM%6)) || rm -rf ~

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: ERROR: unterminated quoted string... help

SGksCgpPbiA1LzE3LzA1LCBQb3N0Z3JlcyBBZG1pbiA8cG9zdGdyZXNAcHJv
ZHVjdGl2aXR5bWVkaWEuY29tPiB3cm90ZToKPiBJJ20gdHJ5aW5nIHRvIGlu
c2VydCBlbmNyeXB0ZWQgZGF0YSBpbnRvIHRoZSBkYXRhYmFzZSBhbmQgSSdt
IG5vdGljaW5nCj4gZXJyb3IgZGVhbGluZyB3aXRoIHF1b3Rlcy4gQmVsb3cg
aXMgdGhlIGVycm9yIHByaW50IG91dC4uLgo+Cj4gc3VnZ2VzdGlvbnMgYW5k
L29yIGF0IGxlYXN0IHBvaW50IG1lIGluIHRoZSBkaXJlY3Rpb24gdG8gZmlu
ZCBhIHNvbHV0aW9uLAo+Cj4gSU5TRVJUIElOVE8gc2FtcGxlLnVzZXJzICh1
c2VyX25hbWUsIGZpcnN0X25hbWUpIFZBTFVFUwo+ICgnam9rZXJzJywgJz3D
r8K1BmlGFyHCtjYow5bFuMOjwo3CvsOzf8uGCMOMJyctSXfigLBpRMOWaUrD
kMO/4oCgICUnKQpJZiB5b3UgZG9uJ3QgdXNlIHBhcmFtZXRlcnMsIHlvdSBu
ZWVkIHRvIGVzY2FwZSB0aGUgZGF0YSB0byBwbGFjZSBpbgphbiBTUUwgcXVl
cnkgY29tbWFuZC4gQnV0IHRoaXMgbWF5IGNvc3Qgc28gbXVjaCBvbiB0aGUg
Q1BVIGFuZCBSQU0Kc2lkZSBpZiB5b3VyIHdpbGwgYmUgZXNjYXBlZCBkYXRh
IGlzIGVub3VnaCBsb25nIHRvIGV4aGF1c3Qgb3RoZXIKcHJvY2Vzc2VzLiAo
Rm9yIGV4YW1wbGUsIGl0J3Mgbm90IHNvIGZlYXNpYmxlIHRvIHVuZXNjYXBl
IGEgbWVkaWEgZmlsZQp3aGlsZSBpbnNlcnRpbmcuKQoKQXQgdGhlIG1vbWVu
dCwgY3VycmVudCBzdGFibGUgcmVsZWFzZXMgb2YgUEhQIGRvZXNuJ3Qgc3Vw
cG9ydApwYXJhbWV0ZXIgdXNhZ2UsIGJ1dCBpdCB3YXMgY29tbWl0dGVkIHRv
IENWUyBpbiByZXZpc2lvbiAxLjMxNS4gSWYKeW91J2xsIG5lZWQgdGhlc2Ug
a2luZCBvZiBlc2NhcGUgZnVuY3Rpb25zIHNvIG11Y2gsIEknZCBlbmNvdXJh
Z2UgeW91CnRvIHBhdGNoIHlvdXIgcGhwL2V4dC9wZ3NxbC9wZ3NxbC5jIHdp
dGggdGhlIG9uZSBpbiBDVlMgdHJlZS4gQWZ0ZXIKcGF0Y2gsIHlvdSdsbCBi
ZSBhYmxlIHRvIHVzZSBwZ19xdWVyeV9wYXJhbXMsIHBnX3ByZXBhcmUsIHBn
X2V4ZWN1dGUsCnBnX3NlbmRfcXVlcnlfcGFyYW1zIGFuZCBwZ19zZW5kX3By
ZXBhcmU7IG5hbWVseSwgZXZlcnkgcG9zc2libGUKcGFyYW1ldGVyIHN1cHBv
cnRlZCBmdW5jdGlvbi4KClJlZ2FyZHMuCgotLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0oZW5kIG9mIGJyb2FkY2FzdCktLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0KVElQIDU6IEhhdmUgeW91IGNoZWNrZWQgb3VyIGV4dGVuc2l2
ZSBGQVE/CgogICAgICAgICAgICAgICBodHRwOi8vd3d3LnBvc3RncmVzcWwu
b3JnL2RvY3MvZmFxCg==