From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | psql-odbc(at)postgresql(dot)org |
Subject: | conversion problem |
Date: | 2005-01-04 18:06:19 |
Message-ID: | 41DADB1B.70402@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
When trying to insert strings with German umlaute (e.g. "täglich") into
a text or varchar column, the server throws the message
invalid byte sequence for encoding "UNICODE": 0xe4656c
This results from ResolveOneParam not converting the string to UTF-8.
Digging into this, I found that
ipdopts->parameters[param_number].SQLType contains 0xffff, instead of
something sensible for PGType=0x19 (text).
The attached patch works as hotfix for me, but is certainly only a
workaround for a problem buried deeper because SQLType seems bogus to me.
OTOH, I don't understand why the switch(param_pgtype) was invented at
all (the original patch I posted more than a year ago didn't have it),
because any string coming from the app will probably need conversion to
UTF-8 anyway.
Regards,
Andreas
Attachment | Content-Type | Size |
---|---|---|
convert.c.patch | text/x-patch | 517 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2005-01-04 18:20:30 | conversion problem |
Previous Message | innenka innenka | 2005-01-03 21:56:21 | error de ODBC |