BUG #15637: Problem insert data 【Japanese】
От | PG Bug reporting form |
---|---|
Тема | BUG #15637: Problem insert data 【Japanese】 |
Дата | |
Msg-id | 15637-4189f44523cbafd9@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15637: Problem insert data 【Japanese】
Re: BUG #15637: Problem insert data 【Japanese】 |
Список | 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 по дате отправления: