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: ----------- Tabella "public.pictures" Colonna | Tipo | Modificatori ------------------+--------+------------------------------------------------------- id | bigint | not null default nextval('pictures_id_seq'::regclass) thumb | bytea | image | bytea | description | text | Indici: "pictures_pkey" PRIMARY KEY, btree (id) ----------- I have tried also to create manually the database with the option -E UTF-8, but no change. (By the way how can this done in GAMBAS ? as databaseConnection.Databases.Add(DBName) does not permit other parameters) I do not understand if the problem is in PostgreSQL or in GAMBAS.... It seems that that picture is treated as a text string instead of a blob. Thanks for any idea. (PostgreSQL 8.3, GAMBAS 2.14, Debian 5.0.1, QT) Pino -- Key ID: 0xF6768208 Key fingerprint = B16D 0A7C 5B29 A334 CE6A 71F6 EAF8 3D88 F676 8208 Key server: hkp://wwwkeys.eu.pgp.net ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user