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

Re: Trouble with encoding again

From: "Alejandro D(dot) Burne" <alejandro(dot)dburne(at)gmail(dot)com>
To: Andrus <eetasoft(at)online(dot)ee>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Trouble with encoding again
Date: 2005-08-28 20:49:24
Message-ID: 8398dc6d050828134941a2c1aa@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
2005/8/25, Andrus <eetasoft(at)online(dot)ee>:
> 
> ""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.
> 
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

In response to

pgsql-odbc by date

Next:From: FatmanDate: 2005-08-29 08:57:00
Subject: conectividad postgresql con access
Previous:From: Dave PageDate: 2005-08-27 08:26:52
Subject: Re: Four part names

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