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
pgsql-odbc by date
|Next:||From: Andreas Pflug||Date: 2005-01-04 18:20:30|
|Subject: conversion problem|
|Previous:||From: innenka innenka||Date: 2005-01-03 21:56:21|
|Subject: error de ODBC|