From: Premsun Choltanwanich <Premsun@nsasia.co.th>
To: getsreejith@gmail.com
To: pgsql-sql@postgresql.org
To: lawgon@thenilgiris.com
Subject: Re: Image Insert Postgresql DB
Date: Tue, 23 Nov 2004 15:19:15 +0700
Message-ID: <s1a3550e.053@jupiter.nsasia.co.th> (raw)
I use VB as develop tool and ADO for connect. My code is show below and
for vPicMember is stand ADOStream in Binary.
rs.Open "SELECT * FROM t_mbrpic WHERE mbrsysid = " & vSysId, conn,
adOpenStatic, adLockOptimistic
If rs.EOF Then rs.AddNew
rs!MbrSysId = vSysId
rs!MbrPic = vPicMember.Read
rs.Update
rs.Close
In this case, Is I must still escape the octets with \\ that is two
backslashes? Could anybody has some suggestion?
>>> Kenneth Gonsalves <lawgon@thenilgiris.com> 23/11/2004 2:40:27 pm
>>>
On Tuesday 23 November 2004 12:48 pm, Premsun Choltanwanich wrote:
> I face this same problem when I try to insert image by lo_import to
> database with my client files. I already change the way to bytea
data
> type but it's not work. The error return like type mismatch when I
try
> to insert it from Binary variable.
>
> Why I cannot insert it? If anybody found some solution please reply
on
> this topic for me too.
you must escape the octets with \\ that is two backslashes and not one
backslash.
for example if your binary data is like this:
\x05\x00\x02
you must make it like so:
\\x05\\x00\\x02
please see chapter 8.4 of the postgresql manual.
kg
---------------------------(end of
broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Premsun@nsasia.co.th, getsreejith@gmail.com, lawgon@thenilgiris.com
Subject: Re: Image Insert Postgresql DB
In-Reply-To: <s1a3550e.053@jupiter.nsasia.co.th>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox