From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Sabino Mullane <htamfids@gmail.com>
cc: Igor Korot <ikorot01@gmail.com>,
        "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: Why that query fails?
In-reply-to: <CAKAnmm+T9=yKB2kuWUAMaZ9jipbkQGJFbCfmq0z6cJ_OAw2M4g@mail.gmail.com>
References: <CA+FnnTy3D3Zo0XxNe37w5FnmGftvv_jWuLVMdS0Y3qPanx2seA@mail.gmail.com> <CAKAnmm+T9=yKB2kuWUAMaZ9jipbkQGJFbCfmq0z6cJ_OAw2M4g@mail.gmail.com>
Comments: In-reply-to Greg Sabino Mullane <htamfids@gmail.com>
	message dated "Sun, 26 Apr 2026 18:17:04 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2423211.1777244361.1@sss.pgh.pa.us>
Date: Sun, 26 Apr 2026 18:59:21 -0400
Message-ID: <2423212.1777244361@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/2423212.1777244361%40sss.pgh.pa.us>
Precedence: bulk

Greg Sabino Mullane <htamfids@gmail.com> writes:
> You are using binary format, but your length calculation is wrong:
> int len1 = (int) name.length() * sizeof( wchar_t );

I think the actual problem is that he's trying to send an array
of wchar_t to the server.  That is not bit-compatible with UTF-8,
even though they are both representations of Unicode.  The query
string itself has the same problem I think (I believe the L"..."
syntax in C produces an array of wchar_t).

			regards, tom lane