Re: [Gambas-user] PictureDatabase with PostgreSQL

2009-07-17 Thread Pino Zollo
Il mercoledì 15 luglio 2009 18:09:51 richard terry ha scritto: > > By the time I was reading the PosgreSQL  documentation. There it explains > > a totally different way of handling blobs. > > > > They use the internal function pg_lo_import to import into the DB a large > > object. > > This returns

Re: [Gambas-user] PictureDatabase with PostgreSQL

2009-07-15 Thread Pino Zollo
Il mercoledì 15 luglio 2009 18:09:51 richard terry ha scritto: > > By the time I was reading the PosgreSQL  documentation. There it explains > > a totally different way of handling blobs. > > > > They use the internal function pg_lo_import to import into the DB a large > > object. > > This returns

Re: [Gambas-user] PictureDatabase with PostgreSQL

2009-07-15 Thread Pino Zollo
Il martedì 14 luglio 2009 17:56:49 richard terry ha scritto: > Hope this helps. > > Regards > > Richard Thanks Richard, yes it helpsnow I am going to put it into the PictureDatabase program. So actually the stream of byte is converted to octal to avoid coding problem. Is there also some rever

Re: [Gambas-user] PictureDatabase with PostgreSQL

2009-07-15 Thread Rolf Schmidt
Hi Pino, > I am trying to use the example "PictureDatabase" with PostgreSQL but I get > the following error: > > "Invalid byte sequence for encoding UTF-8" > In Debian, the PostgreSQL database will created on install-time with the charset of the root, usually of the national language. I have had

Re: [Gambas-user] PictureDatabase with PostgreSQL

2009-07-14 Thread richard terry
On Wed, 15 Jul 2009 04:07:28 am Pino Zollo wrote: > Hi, > > I am trying to use the example "PictureDatabase" with PostgreSQL but I get > the following error: > > "Invalid byte sequence for encoding UTF-8" > > when executes the instruction: > > newPicture.Update() > > in PUBLIC SUB Add(ImagePath AS

[Gambas-user] PictureDatabase with PostgreSQL

2009-07-14 Thread Pino Zollo
Hi, I am trying to use the example "PictureDatabase" with PostgreSQL but I get the following error: "Invalid byte sequence for encoding UTF-8" when executes the instruction: newPicture.Update() in PUBLIC SUB Add(ImagePath AS String) The creation of the database structure seems correct: ---