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 |
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 |