Re: VARCHAR, CHAR types changed ?

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of
> lothar.behrens@lollisoft.de
> Sent: 25 November 2005 12:09
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] VARCHAR, CHAR types changed ?
>
> Hi,
>
> I am trying the new, or most actual database under Windows 2000 (8.0).
> This driver don't let
> my test application crash. Compared to the old driver and Database
> (07.03.0200), my
> other application should run too.
>
> But I get some unexplainable changes in supported types. My
> VARCHAR(100) and even,
> if I change it to CHAR(100), isn't any more supported.
>
> (The error message from me reports -8 as DataType)
>
> What has been changed ?

Looks like you are using the unicode version of the driver (-8 is
SQL_C_WCHAR). You could either:

- Change to the ANSI driver, which should never return SQL_C_WCHAR.
- Update your code to handle Unicode data.
- Update your code to recognise SQL_C_WCHAR, but then request SQL_C_CHAR
data instead.

I would plump for the first option, unless you want to support Unicode.

Regards, Dave.