BUG #15637: Problem insert data 【Japanese】 - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15637: Problem insert data 【Japanese】
Date
Msg-id 15637-4189f44523cbafd9@postgresql.org
Whole thread Raw
Responses Re: BUG #15637: Problem insert data 【Japanese】
Re: BUG #15637: Problem insert data 【Japanese】
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15637
Logged by:          Thanh Huynh Van
Email address:      thanhhv26@gmail.com
PostgreSQL version: 11.1
Operating system:   Window Server 2012 Standard
Description:

I created table has a column 【"C_VAL" character varying(10)】 after that I
insert data【'不具合管理報告書': length=24】. It was inserted successfully => this is
problem.
* Details:
-- Step 1: Create table. Data length of "C_VAL" column = 10
create table "USER02"."T_331_VARCHAR" (
  "ID" numeric not null
  , "C_VAL" character varying(10)
  , primary key ("ID")
);
-- Step 2: Check data length. OCTET_LENGTH('不具合管理報告書') = 24
SELECT OCTET_LENGTH('不具合管理報告書');
-- Step 3: Insert data. Length '不具合管理報告書' = 24
INSERT INTO "USER02"."T_331_VARCHAR"("ID", "C_VAL")
VALUES(1,'不具合管理報告書');
-- Step 4: Check length of inserted data
SELECT OCTET_LENGTH("C_VAL"), * FROM "USER02"."T_331_VARCHAR";
=> Why 【Step 3】was successful ?. Can you help me ?
Thank you !


pgsql-bugs by date:

Previous
From: Doug Safreno
Date:
Subject: Bug: Deferred FKey Check Happening on Double Update, Not Single
Next
From: Thomas Munro
Date:
Subject: Re: BUG #15636: PostgreSQL 11.1 pg_basebackup backup to a CIFSdestination throws fsync error at end of backup