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】  (Marc Schablewski <ms@clickware.de>)
Re: BUG #15637: Problem insert data 【Japanese】  (Francisco Olarte <folarte@peoplecall.com>)
Список 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 по дате отправления:

Предыдущее
От: Doug Safreno
Дата:
Сообщение: Bug: Deferred FKey Check Happening on Double Update, Not Single
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: BUG #15636: PostgreSQL 11.1 pg_basebackup backup to a CIFSdestination throws fsync error at end of backup