Re: About Unicode IVS - Mailing list pgsql-admin

From David G. Johnston
Subject Re: About Unicode IVS
Date
Msg-id CAKFQuwYCTmp5t5_7n+qRoKZArnBvv309CSi4XVdONXxQL6OX0Q@mail.gmail.com
Whole thread Raw
In response to About Unicode IVS  (荒井元成 <n2029@ndensan.co.jp>)
Responses RE: About Unicode IVS  (荒井元成 <n2029@ndensan.co.jp>)
List pgsql-admin


On Monday, March 28, 2022, 荒井元成 <n2029@ndensan.co.jp> wrote:

Hi,

 

In the Length () function, it will be 2 characters where you want it to be 1 character.

Is it possible to respond by changing the settings such as changing the collation setting like SQL Server?
Also, if you understand how to deal with it (eg, create your own function), it would be helpful if you could provide as much information as you can.

 


Try char_length(text) instead.

David J.
 

pgsql-admin by date:

Previous
From: 荒井元成
Date:
Subject: About Unicode IVS
Next
From: 荒井元成
Date:
Subject: RE: About Unicode IVS