Hi Igor, This doesn't look like a driver problem, and I don't think you need to forward it to the PG-ODBC list. The truncation comes from the BufferLength argument you pass to SQLBindCol.
BufferLength is expressed in BYTES, not in characters. SQLWCHAR is 2 bytes on your platform, so a value of 33 gives the driver room for 16 SQLWCHARs: 15 characters plus the terminating null. That is exactly what you see: "BenefitsCheckBo" is 15 characters, followed by the 0 in your gdb dump. Your cbStyleName = 32 is the driver telling you it had 32 bytes (16 characters) of data available, which is more than your buffer could hold. The driver most likely returned SQL_SUCCESS_WITH_INFO (SQLSTATE 01004, string data, right truncated), and your loop accepts that code silently. Suggested fixes: 1. Pass the real buffer size in bytes: SQLBindCol( m_hstmt, 1, SQL_C_WCHAR, styleName, sizeof( styleName ), &cbStyleName ); and likewise sizeof( styleStyle ) and sizeof( work ). Right now styleStyle[255] is also bound with 33 bytes, although abe_edit can hold 254 characters. Also make sure the arrays are large enough for the column length + 1 (abe_name is varchar(30), so 31 SQLWCHARs is the minimum). 2. Match the C types to the column types. abe_flag is an integer with values like 536870916 and -201326590, but you bind it as SQL_C_USHORT, which keeps only the low 16 bits. Use SQL_C_SLONG with a SQLINTEGER. For the smallint columns, use SQL_C_SSHORT with SQLSMALLINT (or SQL_C_SLONG with an int). Binding SQL_C_USHORT to an int variable only works by accident on little-endian machines. 3. Check the indicators for SQL_NULL_DATA before using the buffers. abe_work (and abe_edit) can be NULL, as in the first BenefitsCheckBox row. 4. Log the return value of SQLFetch when it is SQL_SUCCESS_WITH_INFO, and call SQLGetDiagRec to read the diagnostics. It would have shown the truncation immediately. Minor point: in your query buffer, memset( qry.get(), '\0', query.length() + 2 ) clears bytes, not SQLWCHARs, so it should be ( query.length() + 2 ) * sizeof( SQLWCHAR ). It doesn't matter if uc_to_str_cpy terminates the string, but it's worth fixing. Hope this helps. Envoyé à partir de Outlook pour Android<https://aka.ms/AAb9ysg> ________________________________ From: rob stone <[email protected]> Sent: Sunday, 15 November 2026 12:25:58 To: Igor Korot <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> Subject: Re: Problem retrieving data On Sun, 2026-11-15 at 01:11 -0600, Igor Korot wrote: > $9 = 0x65 <error: Cannot access memory at address 0x65> Maybe this ought to be rectified?
