Message-Id: <s1a3550e.053@jupiter.nsasia.co.th>
Date: Tue, 23 Nov 2004 15:19:15 +0700
From: "Premsun Choltanwanich" <Premsun@nsasia.co.th>
To: <getsreejith@gmail.com>, <pgsql-sql@postgresql.org>,
	<lawgon@thenilgiris.com>
Subject: Re: Image Insert Postgresql DB
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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