MIME-Version: 1.0
References: <39e35073-0cac-5d64-9a72-b47ea671fb20@gmx.de>
In-Reply-To: <39e35073-0cac-5d64-9a72-b47ea671fb20@gmx.de>
From: "Inoue,Hiroshi" <hinoue205@gmail.com>
Date: Wed, 30 Nov 2022 20:19:52 +0900
Message-ID: 
 <CAFGcedVioNNaedu4fiCFNOL=7LKC41gf5eWgDCz3CHd-CL8K3g@mail.gmail.com>
Subject: Re: SQLGetConnectAttrW + SQL_ATTR_CURRENT_CATALOG => wrong byte
 count?
To: Marsupilami79 <marsupilami79@gmx.de>
Cc: pgsql-odbc@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000546bc705eeae4906"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFGcedVioNNaedu4fiCFNOL%3D7LKC41gf5eWgDCz3CHd-CL8K3g%40mail.gmail.com>
Precedence: bulk

--000000000000546bc705eeae4906
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Jan,

The psqlodbc unicode driver correctly returns the number of bytes(10 bytes
for a database name "visco")  here.

regards,
Hiroshi Inoue

2022=E5=B9=B411=E6=9C=8823=E6=97=A5(=E6=B0=B4) 0:57 Marsupilami79 <marsupil=
ami79@gmx.de>:

> Hello,
>
> I am a co author of a data access library and we recently added an ODBC
> bridge. This bridge has the capability to detemine the current Catalog /
> Database. This is done by calling SQLGetConnectAttrW.
>
> We try to determine the size of the buffer that is needed for the
> catalog name in the following manner:
> SQLGetConnectAttrW(fHDBC, SQL_ATTR_CURRENT_CATALOG, null, 0, &aLen)
>
> The ODBC driver for Microsoft SQL server correctly returns the number of
> bytes required (10 bytes for the Database name "Stork") in the aLen
> parameter. The ODBC driver for PostgreSQL returns the number of
> characters (8 characters for a database named "topsales"), where it
> should return 16 for the number of bytes required.
>
> I tested this with the psqlodbc_13_02_0000-x86 download for Windows 10
> and installed the Unicode ODBC driver.
>
> I assume this is a bug and needs to be fixed. I just don't know if this
> is the right place to report the bug to?
>
> With best regards,
>
> Jan
>
>
>

--000000000000546bc705eeae4906
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi Jan,</div><div dir=3D"ltr"><br></div><=
div>The=C2=A0psqlodbc unicode driver correctly returns the number of bytes(=
10 bytes for a database name &quot;visco&quot;)=C2=A0 here.</div><div><br><=
/div><div>regards,</div><div>Hiroshi Inoue</div><br><div class=3D"gmail_quo=
te"><div dir=3D"ltr" class=3D"gmail_attr">2022=E5=B9=B411=E6=9C=8823=E6=97=
=A5(=E6=B0=B4) 0:57 Marsupilami79 &lt;<a href=3D"mailto:marsupilami79@gmx.d=
e" target=3D"_blank">marsupilami79@gmx.de</a>&gt;:<br></div><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
I am a co author of a data access library and we recently added an ODBC<br>
bridge. This bridge has the capability to detemine the current Catalog /<br=
>
Database. This is done by calling SQLGetConnectAttrW.<br>
<br>
We try to determine the size of the buffer that is needed for the<br>
catalog name in the following manner:<br>
SQLGetConnectAttrW(fHDBC, SQL_ATTR_CURRENT_CATALOG, null, 0, &amp;aLen)<br>
<br>
The ODBC driver for Microsoft SQL server correctly returns the number of<br=
>
bytes required (10 bytes for the Database name &quot;Stork&quot;) in the aL=
en<br>
parameter. The ODBC driver for PostgreSQL returns the number of<br>
characters (8 characters for a database named &quot;topsales&quot;), where =
it<br>
should return 16 for the number of bytes required.<br>
<br>
I tested this with the psqlodbc_13_02_0000-x86 download for Windows 10<br>
and installed the Unicode ODBC driver.<br>
<br>
I assume this is a bug and needs to be fixed. I just don&#39;t know if this=
<br>
is the right place to report the bug to?<br>
<br>
With best regards,<br>
<br>
Jan<br>
<br>
<br>
</blockquote></div></div>

--000000000000546bc705eeae4906--