BUG #15637: Problem insert data 【Japanese】

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: thanhhv26(at)gmail(dot)com
Subject: BUG #15637: Problem insert data 【Japanese】
Date: 2019-02-15 02:43:02
Message-ID: 15637-4189f44523cbafd9@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15637
Logged by: Thanh Huynh Van
Email address: thanhhv26(at)gmail(dot)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 !

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2019-02-15 04:10:42 Re: BUG #15636: PostgreSQL 11.1 pg_basebackup backup to a CIFS destination throws fsync error at end of backup
Previous Message Doug Safreno 2019-02-15 00:32:08 Bug: Deferred FKey Check Happening on Double Update, Not Single