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

Re: Trouble with encoding again

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Trouble with encoding again
Date: 2005-08-25 18:12:07
Message-ID: del1n5$1pp4$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
""Alejandro D. Burne"" <alejandro(dot)dburne(at)gmail(dot)com> wrote in message 
news:8398dc6d0508240658290fc36e(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
> Hi, I'll be trying to solve this workaround between postgres odbc
> 8.01.00.03 and VisualFoxPro(VFP) with spanish chars and unicode
> encoding.
> VFP''ve 2 ways to send info to rdbms: explicit or by reference:
> A little example (I think it's easy to understand)
> 1) conn=SQLCONNECT('odbc_entry','user','pwd')
> 2) SQLEXECUTE(conn,"INSERT INTO t1 VALUES ('');)")
> 3) a=''
> 4) SQLEXECUTE(conn,"INSERT INTO t1 VALUES (?a);)")
>
> 1) Stablish connection
> 2) Works fine (explicit)
> 3) Var 'a' takes value 
> 4) This doesn't work (by reference)

Use

3) a= STRCONV('',9)

Andrus. 



In response to

Responses

pgsql-odbc by date

Next:From: Zoltan BoszormenyiDate: 2005-08-25 20:33:31
Subject: Re: changed behavior in libpq odbc driver
Previous:From: Bernard Henry VoynetDate: 2005-08-25 13:13:03
Subject: bool tanformed into char

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