Re: problem with CVS version

> -----Original Message-----
> From: Antonio Pennino [mailto:a.pennino@nocerainformatica.net]
> Sent: 27 July 2004 14:18
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: RE: [ODBC] problem with CVS version
>
> Subject:            RE: [ODBC] problem with CVS version
> Date sent:          Tue, 27 Jul 2004 13:27:30 +0100
> From:               "Dave Page" <dpage@vale-housing.co.uk>
> To:                 "Antonio Pennino"
> <a.pennino@nocerainformatica.net>
> Copies to:          <pgsql-odbc@postgresql.org>
>
> > Hmm, there's nothing in there that looks odd to me, but then I've
> > never dug quite this deep into the driver before. I assume
> '#eliminato'
> > translates to '#deleted'?
>
> Yes, but is NOT only a MS-ACCESS 97 problem because with my
> dump utility a see m_nSQLType (MFC) = -9 !!!

As I said, -9 is SQL_WVARCHAR which is a perfectly valid type. Your
application is calling the *W version of various SQL functions (or the
driver manager is mapping your calls to them because it is detecting
that your app is Unicode aware - as per the ODBC spec), so it should be
able to recognise a unicode data type.

> Perhaps the ::SQLDescribeCol() is deprecated for psql but MFC
> use it and i CAN NOT write my code without the MFC framework.

SQLDescribeCol is most certainly supported.

> If, instead of the CVS version and/or the beta version from
> Dave, i use an older (7.1.2004) version of psqlodbc.dll,
> m_nSQLType is = 12.

Yes, because the older driver did not support unicode.

Regard, Dave.