| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Cynthia Hombakazi Ngejane <hombakazi(dot)ngejane(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Syncing Data of data type BLOB into Postgres- Bytea |
| Date: | 2016-11-14 15:14:39 |
| Message-ID: | 173521f7-11c5-4dc7-60ef-3383b9dd40f4@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/13/2016 11:40 PM, Cynthia Hombakazi Ngejane wrote:
> 9.3
> it just says syntax error near (
> I have a variable QByteArray that stores the fingerprint data, then:
> I am using QString Query = "insert into tableName(colName) values
> (:valName)";
> prepare the query;
> then query.bindValue;
>
> lastly query.exec();
>
On my last post I never did get to the point I was trying to make, that
this this may be a string escaping issue. To help with identifying the
problem it would be good to know the value of:
standard_conforming_strings
in postgresql.conf and whether it is commented out or not.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerome Wagner | 2016-11-14 15:16:09 | Re: Converting a TimestampTz into a C# DateTime |
| Previous Message | Adrian Klaver | 2016-11-14 14:58:44 | Re: Syncing Data of data type BLOB into Postgres- Bytea |