2005/8/25, Andrus <eetasoft@online.ee>:
>
> ""Alejandro D. Burne"" <alejandro.dburne@gmail.com> wrote in message
> news:8398dc6d0508240658290fc36e@mail.gmail.com...
> > 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.
>
Thanks for your reply, but I'm not using UNICODE encoding, just
LATIN10. Another tip is odbc driver 7.03.02.00 works fine (just
SQLCancel() workaround problem)
Alejandro