Skip site navigation (1) Skip section navigation (2)

Postgresql odbc column bytea problem

From: "Mario Soto" <mario_soto(at)venezolanadeavaluos(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Postgresql odbc column bytea problem
Date: 2004-07-29 17:02:37
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Hellow please,

Hi i have a aplication in visual basic 6. it connect to postgresql via odbc

the connection string its

strCn =

well i create a table:

CREATE TABLE "public"."crypto" (
  "campo1" BYTEA

and insert the data:

stsql = " insert into crypto(campo1) values (
  encrypt('prueba', 'fooz', 'bf'))"

and its ok

but when do:
stSQL = "select  decrypt(campo1, 'fooz', 'bf') as valor From crypto"

the result return say: ??

please any idea thank

Ing. Mario Soto Cordones
 Venezolana de Avaluos

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

pgsql-odbc by date

Next:From: Janet BorschowaDate: 2004-07-29 19:22:10
Subject: Re: problem with CVS version
Previous:From: Antonio PenninoDate: 2004-07-29 15:33:13
Subject: Re: problem with CVS version

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group