Re: When length of text data is 1.

НФСР wrote:
> Hello,
>
> I tried to search in Internet, but didn't find answer...
> I'm using PostgreSQL 8.1.5-1, ODBC, MS Visual C++ with MFC, I'm using
> Unicode (database has UTF8 encoding and I'm using "PostgreSQL Unicode" odbc
> driver).
> I create, for example, such table:
>
> ***code***
> CREATE TABLE section (
>     idsection INT PRIMARY KEY,")
>     idparent INT NULL REFERENCES section ON DELETE CASCADE,")
>     name TEXT NOT NULL")
>    );
> **********
>
> Retrieve data thereby:
>
> ***code***
> CRecordset rcrd(&db);
> CString nm;
> ....
> rcrd.GetFieldValue(_T("name"),nm);
> **********
>
> It works without any problem except when length of 'name' is 1.
> For example, It works fine when name is 'John' but when name is 'J' line
>    rcrd.GetFieldValue(_T("name"),nm);
> throws exception with empty exception message and AFAIK with return code
> SQL_NO_DATA.

Which version of ODBC driver are you using ?
Could you send me the Mylog output ?

regards,
Hiroshi Inoue