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 !
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 |