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

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 (view raw or flat)
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: mylog_448.zip
Description: application/zip (3.0 KB)

pgsql-odbc by date

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

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