| 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: | Whole Thread | Raw Message | 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 |