MIME-Version: 1.0
References: <CA+FnnTy3D3Zo0XxNe37w5FnmGftvv_jWuLVMdS0Y3qPanx2seA@mail.gmail.com>
In-Reply-To: <CA+FnnTy3D3Zo0XxNe37w5FnmGftvv_jWuLVMdS0Y3qPanx2seA@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Sun, 26 Apr 2026 18:17:04 -0400
Message-ID: <CAKAnmm+T9=yKB2kuWUAMaZ9jipbkQGJFbCfmq0z6cJ_OAw2M4g@mail.gmail.com>
Subject: Re: Why that query fails?
To: Igor Korot <ikorot01@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ad04a40650645d0a"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmm%2BT9%3DyKB2kuWUAMaZ9jipbkQGJFbCfmq0z6cJ_OAw2M4g%40mail.gmail.com>
Precedence: bulk

--000000000000ad04a40650645d0a
Content-Type: text/plain; charset="UTF-8"

You are using binary format, but your length calculation is wrong:

int len1 = (int) name.length() * sizeof( wchar_t );

Just use text format for a query like this.

--000000000000ad04a40650645d0a
Content-Type: text/html; charset="UTF-8"

<div dir="ltr">You are using binary format, but your length calculation is wrong:<div><br></div><div>int len1 = (int) name.length() * sizeof( wchar_t );</div><div><br></div><div>Just use text format for a query like this.</div><div><br></div></div>

--000000000000ad04a40650645d0a--