Trouble with encoding

From: "Alejandro D(dot) Burne" <alejandro(dot)dburne(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Trouble with encoding
Date: 2005-08-24 11:07:25
Message-ID: 8398dc6d05082404073ff41a1e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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 for 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 (for reference)
This issue works with any other rdbms I tryed (M$SQL, MySQL, Sybase),
including postgres odbc 7.03.02.00 on LATIN10 encoding.

Thanks. Alejandro.

Attachment Content-Type Size
mylog_448.zip application/zip 3.0 KB

Browse pgsql-odbc by date

  From Date Subject
Next Message Alejandro D. Burne 2005-08-24 13:58:41 Trouble with encoding again
Previous Message Dave Page 2005-08-24 09:49:09 Re: "Official" version