conversion problem

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: conversion problem
Date: 2005-01-04 18:20:30
Message-ID: 41DADE6E.2000903@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.
From debugging 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 518 bytes

Browse pgsql-odbc by date

  From Date Subject
Next Message Pailloncy Jean-Gerard 2005-01-04 23:55:09 iodbc & OpenBSD
Previous Message Andreas Pflug 2005-01-04 18:06:19 conversion problem