From 67c26c12aff7d5c41e82b5e220a435e943095bfc Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Sat, 22 Sep 2001 08:47:20 +0000 Subject: [PATCH] Fix expected files. --- src/test/mb/expected/big5.out | 1 - src/test/mb/expected/euc_cn.out | 87 +++++-- src/test/mb/expected/euc_kr.out | 87 +++++-- src/test/mb/expected/euc_tw.out | 85 ++++-- src/test/mb/expected/mule_internal.out | 167 ++++++------ src/test/mb/expected/unicode.out | 344 +++++-------------------- 6 files changed, 360 insertions(+), 411 deletions(-) diff --git a/src/test/mb/expected/big5.out b/src/test/mb/expected/big5.out index 8ba6a9a25f..110bf8c7a3 100644 --- a/src/test/mb/expected/big5.out +++ b/src/test/mb/expected/big5.out @@ -1,5 +1,4 @@ drop table ¼t°Ó¸ê®Æ; -ERROR: table "¼t°Ó¸ê®Æ" does not exist create table ¼t°Ó¸ê®Æ (¦æ·~§O text, ¤½¥q©ïÀY varchar, ¦a§} varchar(16)); create index ¼t°Ó¸ê®Æindex1 on ¼t°Ó¸ê®Æ using btree (¦æ·~§O); create index ¼t°Ó¸ê®Æindex2 on ¼t°Ó¸ê®Æ using hash (¤½¥q©ïÀY); diff --git a/src/test/mb/expected/euc_cn.out b/src/test/mb/expected/euc_cn.out index 8b80d6d584..71068f8c55 100644 --- a/src/test/mb/expected/euc_cn.out +++ b/src/test/mb/expected/euc_cn.out @@ -1,38 +1,87 @@ drop table ¼ÆËã»úÊõÓï; -ERROR: parser: parse error at or near "(" +ERROR: table "¼ÆËã»úÊõÓï" does not exist create table ¼ÆËã»úÊõÓï(ÊõÓï text, ·ÖÀàºÅ varchar, ±¸×¢1A char(16)); -ERROR: parser: parse error at or near "(" create index ¼ÆËã»úÊõÓïindex1 on ¼ÆËã»úÊõÓï using btree(ÊõÓï); -ERROR: parser: parse error at or near "(" create index ¼ÆËã»úÊõÓïindex2 on ¼ÆËã»úÊõÓï using btree(·ÖÀàºÅ); -ERROR: parser: parse error at or near "(" insert into ¼ÆËã»úÊõÓï values('µçÄÔÏÔʾÆÁ','»úA01ÉÏ'); -ERROR: parser: parse error at or near "(" insert into ¼ÆËã»úÊõÓï values('µçÄÔͼÐÎ','·ÖB01ÖÐ'); -ERROR: parser: parse error at or near "(" insert into ¼ÆËã»úÊõÓï values('µçÄÔ³ÌÐòÔ±','ÈËZ01ÏÂ'); -ERROR: parser: parse error at or near "(" vacuum ¼ÆËã»úÊõÓï; -ERROR: parser: parse error at or near "(" select * from ¼ÆËã»úÊõÓï; -ERROR: parser: parse error at or near "92" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a +------------+---------+-------- + µçÄÔÏÔʾÆÁ | »úA01ÉÏ | + µçÄÔͼÐÎ | ·ÖB01ÖÐ | + µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | +(3 rows) + select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ = 'ÈËZ01ÏÂ'; -ERROR: parser: parse error at or near "92" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a +------------+---------+-------- + µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | +(1 row) + select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ ~* 'ÈËz01ÏÂ'; -ERROR: parser: parse error at or near "92" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a +------------+---------+-------- + µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | +(1 row) + select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ like '_Z01_'; -ERROR: parser: parse error at or near "92" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a +------------+---------+-------- + µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | +(1 row) + select * from ¼ÆËã»úÊõÓï where ·ÖÀàºÅ like '_Z%'; -ERROR: parser: parse error at or near "92" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a +------------+---------+-------- + µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | +(1 row) + select * from ¼ÆËã»úÊõÓï where ÊõÓï ~ 'µçÄÔ[ÏÔͼ]'; -ERROR: parser: parse error at or near "92" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a +------------+---------+-------- + µçÄÔÏÔʾÆÁ | »úA01ÉÏ | + µçÄÔͼÐÎ | ·ÖB01ÖÐ | +(2 rows) + select * from ¼ÆËã»úÊõÓï where ÊõÓï ~* 'µçÄÔ[ÏÔͼ]'; -ERROR: parser: parse error at or near "92" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a +------------+---------+-------- + µçÄÔÏÔʾÆÁ | »úA01ÉÏ | + µçÄÔͼÐÎ | ·ÖB01ÖÐ | +(2 rows) + select *,character_length(ÊõÓï) from ¼ÆËã»úÊõÓï; -ERROR: parser: parse error at or near "caf5" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | char_length +------------+---------+--------+------------- + µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | 5 + µçÄÔͼÐÎ | ·ÖB01ÖÐ | | 4 + µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | 5 +(3 rows) + select *,octet_length(ÊõÓï) from ¼ÆËã»úÊõÓï; -ERROR: parser: parse error at or near "caf5" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | octet_length +------------+---------+--------+-------------- + µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | 10 + µçÄÔͼÐÎ | ·ÖB01ÖÐ | | 8 + µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | 10 +(3 rows) + select *,position('ÏÔ' in ÊõÓï) from ¼ÆËã»úÊõÓï; -ERROR: parser: parse error at or near "caf5" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | position +------------+---------+--------+---------- + µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | 3 + µçÄÔͼÐÎ | ·ÖB01ÖÐ | | 0 + µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | 0 +(3 rows) + select *,substring(ÊõÓï from 3 for 4) from ¼ÆËã»úÊõÓï; -ERROR: parser: parse error at or near "caf5" + ÊõÓï | ·ÖÀàºÅ | ±¸×¢1a | substring +------------+---------+--------+----------- + µçÄÔÏÔʾÆÁ | »úA01ÉÏ | | ÏÔʾÆÁ + µçÄÔͼÐÎ | ·ÖB01ÖÐ | | ͼÐÎ + µçÄÔ³ÌÐòÔ± | ÈËZ01Ï | | ³ÌÐòÔ± +(3 rows) + diff --git a/src/test/mb/expected/euc_kr.out b/src/test/mb/expected/euc_kr.out index 85282e627f..8b90c4d76e 100644 --- a/src/test/mb/expected/euc_kr.out +++ b/src/test/mb/expected/euc_kr.out @@ -1,38 +1,87 @@ drop table ͪߩѦ¿ë¾î; -ERROR: parser: parse error at or near "(" +ERROR: table "ͪߩѦ¿ë¾î" does not exist create table ͪߩѦ¿ë¾î (¿ë¾î text, ÝÂ×¾ÄÚµå varchar, ºñ°í1A¶ó±¸ char(16)); -ERROR: parser: parse error at or near "(" create index ͪߩѦ¿ë¾îindex1 on ͪߩѦ¿ë¾î using btree (¿ë¾î); -ERROR: parser: parse error at or near "(" create index ͪߩѦ¿ë¾îindex2 on ͪߩѦ¿ë¾î using hash (ÝÂ×¾ÄÚµå); -ERROR: parser: parse error at or near "(" insert into ͪߩѦ¿ë¾î values('ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ', 'ѦA01ß¾'); -ERROR: parser: parse error at or near "(" insert into ͪߩѦ¿ë¾î values('ÄÄÇ»Åͱ׷¡ÇȽº', 'ÝÂB10ñé'); -ERROR: parser: parse error at or near "(" insert into ͪߩѦ¿ë¾î values('ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó', 'ìÑZ01ù»'); -ERROR: parser: parse error at or near "(" vacuum ͪߩѦ¿ë¾î; -ERROR: parser: parse error at or near "(" select * from ͪߩѦ¿ë¾î; -ERROR: parser: parse error at or near "92" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ +------------------+----------+------------ + ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | + ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | + ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | +(3 rows) + select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå = 'ìÑZ01ù»'; -ERROR: parser: parse error at or near "92" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ +------------------+----------+------------ + ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | +(1 row) + select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå ~* 'ìÑz01ù»'; -ERROR: parser: parse error at or near "92" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ +------------------+----------+------------ + ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | +(1 row) + select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z01_'; -ERROR: parser: parse error at or near "92" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ +------------------+----------+------------ + ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | +(1 row) + select * from ͪߩѦ¿ë¾î where ÝÂ×¾ÄÚµå like '_Z%'; -ERROR: parser: parse error at or near "92" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ +------------------+----------+------------ + ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | +(1 row) + select * from ͪߩѦ¿ë¾î where ¿ë¾î ~ 'ÄÄÇ»ÅÍ[µð±×]'; -ERROR: parser: parse error at or near "92" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ +------------------+----------+------------ + ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | + ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | +(2 rows) + select * from ͪߩѦ¿ë¾î where ¿ë¾î ~* 'ÄÄÇ»ÅÍ[µð±×]'; -ERROR: parser: parse error at or near "92" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ +------------------+----------+------------ + ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | + ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | +(2 rows) + select *,character_length(¿ë¾î) from ͪߩѦ¿ë¾î; -ERROR: parser: parse error at or near "bfeb" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | char_length +------------------+----------+------------+------------- + ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | 8 + ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | 7 + ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | 8 +(3 rows) + select *,octet_length(¿ë¾î) from ͪߩѦ¿ë¾î; -ERROR: parser: parse error at or near "bfeb" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | octet_length +------------------+----------+------------+-------------- + ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | 16 + ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | 14 + ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | 16 +(3 rows) + select *,position('µð' in ¿ë¾î) from ͪߩѦ¿ë¾î; -ERROR: parser: parse error at or near "bfeb" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | position +------------------+----------+------------+---------- + ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | 4 + ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | 0 + ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | 0 +(3 rows) + select *,substring(¿ë¾î from 3 for 4) from ͪߩѦ¿ë¾î; -ERROR: parser: parse error at or near "bfeb" + ¿ë¾î | ÝÂ×¾ÄÚµå | ºñ°í1a¶ó±¸ | substring +------------------+----------+------------+----------- + ÄÄÇ»Å͵ð½ºÇ÷¹ÀÌ | ѦA01ß¾ | | Å͵ð½ºÇà + ÄÄÇ»Åͱ׷¡ÇȽº | ÝÂB10ñé | | Åͱ׷¡ÇÈ + ÄÄÇ»ÅÍÇÁ·Î±×·¡¸Ó | ìÑZ01ù» | | ÅÍÇÁ·Î±× +(3 rows) + diff --git a/src/test/mb/expected/euc_tw.out b/src/test/mb/expected/euc_tw.out index f9629f9f78..3b0a0f75d6 100644 --- a/src/test/mb/expected/euc_tw.out +++ b/src/test/mb/expected/euc_tw.out @@ -1,38 +1,85 @@ drop table ìÞÙ¸æñÕè; -ERROR: parser: parse error at or near "(" +ERROR: table "ìÞÙ¸æñÕè" does not exist create table ìÞÙ¸æñÕè (ÈçäÆɱ text, ÄüƳÍñó¤ varchar, ÇâÉß varchar(16)); -ERROR: parser: parse error at or near "(" create index ìÞÙ¸æñÕèindex1 on ìÞÙ¸æñÕè using btree (ÈçäÆɱ); -ERROR: parser: parse error at or near "(" create index ìÞÙ¸æñÕèindex2 on ìÞÙ¸æñÕè using hash (ÄüƳÍñó¤); -ERROR: parser: parse error at or near "(" insert into ìÞÙ¸æñÕè values ('çÙæªäÆ', 'ç®ç®ÒïÊÀ', 'Æ¡A01Äî'); -ERROR: parser: parse error at or near "(" insert into ìÞÙ¸æñÕè values ('êûÝßäÆ', 'ØÂäãÈ´ÓîÄüƳ', 'ÄãB10Äã'); -ERROR: parser: parse error at or near "(" insert into ìÞÙ¸æñÕè values ('ó§ã£äÆ', 'Ó¡ÌÀϴǹȴÓîÄüƳ', 'ØíZ01Ħ'); -ERROR: parser: parse error at or near "(" vacuum ìÞÙ¸æñÕè; -ERROR: parser: parse error at or near "(" select * from ìÞÙ¸æñÕè; -ERROR: parser: parse error at or near "92" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß +--------+------------------+--------- + çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî + êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã + ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ +(3 rows) + select * from ìÞÙ¸æñÕè where ÇâÉß = 'ØíZ01Ħ'; -ERROR: parser: parse error at or near "92" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß +--------+------------------+--------- + ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ +(1 row) + select * from ìÞÙ¸æñÕè where ÇâÉß ~* 'Øíz01Ħ'; -ERROR: parser: parse error at or near "92" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß +--------+------------------+--------- + ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ +(1 row) + select * from ìÞÙ¸æñÕè where ÇâÉß like '_Z01_'; -ERROR: parser: parse error at or near "92" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß +--------+------------------+--------- + ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ +(1 row) + select * from ìÞÙ¸æñÕè where ÇâÉß like '_Z%'; -ERROR: parser: parse error at or near "92" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß +--------+------------------+--------- + ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ +(1 row) + select * from ìÞÙ¸æñÕè where ÄüƳÍñó¤ ~ 'ç®ç®Òï[ÙìØ´ÊÀ]'; -ERROR: parser: parse error at or near "92" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß +--------+----------+--------- + çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî +(1 row) + select * from ìÞÙ¸æñÕè where ÄüƳÍñó¤ ~* 'ç®ç®Òï[ÙìØ´ÊÀ]'; -ERROR: parser: parse error at or near "92" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß +--------+----------+--------- + çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî +(1 row) + select *, character_length(ÈçäÆɱ) from ìÞÙ¸æñÕè; -ERROR: parser: parse error at or near "c8e7" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | char_length +--------+------------------+---------+------------- + çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 3 + êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 3 + ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 3 +(3 rows) + select *, octet_length(ÈçäÆɱ) from ìÞÙ¸æñÕè; -ERROR: parser: parse error at or near "c8e7" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | octet_length +--------+------------------+---------+-------------- + çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 6 + êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 6 + ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 6 +(3 rows) + select *, position('È´Óî' in ÄüƳÍñó¤) from ìÞÙ¸æñÕè; -ERROR: parser: parse error at or near "c4fc" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | position +--------+------------------+---------+---------- + çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | 0 + êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | 3 + ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | 5 +(3 rows) + select *, substring(ÄüƳÍñó¤ from 3 for 6 ) from ìÞÙ¸æñÕè; -ERROR: parser: parse error at or near "c4fc" + ÈçäÆɱ | ÄüƳÍñó¤ | ÇâÉß | substring +--------+------------------+---------+-------------- + çÙæªäÆ | ç®ç®ÒïÊÀ | Æ¡A01Äî | ÒïÊÀ + êûÝßäÆ | ØÂäãÈ´ÓîÄüƳ | ÄãB10Äã | È´ÓîÄüƳ + ó§ã£äÆ | Ó¡ÌÀϴǹȴÓîÄüƳ | ØíZ01Ħ | ϴǹȴÓîÄüƳ +(3 rows) + diff --git a/src/test/mb/expected/mule_internal.out b/src/test/mb/expected/mule_internal.out index 034701277a..983ece1cfd 100644 --- a/src/test/mb/expected/mule_internal.out +++ b/src/test/mb/expected/mule_internal.out @@ -22,66 +22,67 @@ select * from (1 row) select * from ’·×’»»’µ¡’Íђ¸ì where ’ʬ’Îà’¥³’¡¼’¥É ~* '’¿Íz01’²¼'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ---------+-----------------+---------------- -(0 rows) + ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è +--------------------------------------+-----------------+---------------- + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | +(1 row) select * from ’·×’»»’µ¡’Íђ¸ì where ’ʬ’Îà’¥³’¡¼’¥É like '_Z01_'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ---------+-----------------+---------------- -(0 rows) + ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è +--------------------------------------+-----------------+---------------- + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | +(1 row) select * from ’·×’»»’µ¡’Íђ¸ì where ’ʬ’Îà’¥³’¡¼’¥É like '_Z%'; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è ---------+-----------------+---------------- -(0 rows) + ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è +--------------------------------------+-----------------+---------------- + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | +(1 row) select * from ’·×’»»’µ¡’Íђ¸ì where ’Íђ¸ì ~ '’¥³’¥ó’¥Ô’¥å’¡¼’¥¿[’¥Ç’¥°]'; ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è -----------------------------------------+-----------------+---------------- ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | -(3 rows) +(2 rows) select * from ’·×’»»’µ¡’Íђ¸ì where ’Íђ¸ì ~* '’¥³’¥ó’¥Ô’¥å’¡¼’¥¿[’¥Ç’¥°]'; ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è -----------------------------------------+-----------------+---------------- ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | -(3 rows) +(2 rows) select *,character_length(’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | char_length -----------------------------------------+-----------------+----------------+------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 18 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 20 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 18 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 12 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 13 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 12 (3 rows) select *,octet_length(’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | octet_length -----------------------------------------+-----------------+----------------+-------------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 54 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 59 - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 54 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 36 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 39 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 36 (3 rows) select *,position('’¥Ç' in ’Íђ¸ì) from ’·×’»»’µ¡’Íђ¸ì; ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | position -----------------------------------------+-----------------+----------------+---------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 0 + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | 7 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | 0 ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | 0 (3 rows) select *,substring(’Íђ¸ì from 10 for 4) from ’·×’»»’µ¡’Íђ¸ì; - ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | substring ------------------------------------------+-----------------+----------------+----------- - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | ’¥Ç’¥£’¥ - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | ’¥°’¥é’¥ - ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | ’¥×’¥í’¥ + ’Íђ¸ì | ’ʬ’Îà’¥³’¡¼’¥É | ’È÷’¹Í1a’¤À’¤è | substring +-----------------------------------------+-----------------+----------------+-------------- + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥Ç’¥£’¥¹’¥×’¥ì’¥¤ | ’µ¡A01’¾å | | ’¥×’¥ì’¥¤ + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥°’¥é’¥Õ’¥£’¥Ã’¥¯’¥¹ | ’ʬB10’Ãæ | | ’¥£’¥Ã’¥¯’¥¹ + ’¥³’¥ó’¥Ô’¥å’¡¼’¥¿’¥×’¥í’¥°’¥é’¥Þ’¡¼ | ’¿ÍZ01’²¼ | | ’¥é’¥Þ’¡¼ (3 rows) drop table ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; @@ -108,52 +109,57 @@ select * from (1 row) select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘·Ö‘Àà‘ºÅ ~* '‘ÈËz01‘ÏÂ'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ---------+-----------+---------- -(0 rows) + ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a +-----------------+-----------+---------- + ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | +(1 row) select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘·Ö‘Àà‘ºÅ like '_Z01_'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ---------+-----------+---------- -(0 rows) + ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a +-----------------+-----------+---------- + ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | +(1 row) select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘·Ö‘Àà‘ºÅ like '_Z%'; - ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a ---------+-----------+---------- -(0 rows) + ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a +-----------------+-----------+---------- + ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | +(1 row) select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘Êõ‘Óï ~ '‘µç‘ÄÔ[‘Ïԑͼ]'; ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a -----------------+-----------+---------- ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | -(1 row) + ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | +(2 rows) select * from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï where ‘Êõ‘Óï ~* '‘µç‘ÄÔ[‘Ïԑͼ]'; ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a -----------------+-----------+---------- ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | -(1 row) + ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | +(2 rows) select *,character_length(‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | char_length -----------------+-----------+----------+------------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 8 - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 6 - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 8 + ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 5 + ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 4 + ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 5 (3 rows) select *,octet_length(‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | octet_length -----------------+-----------+----------+-------------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 23 - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 18 - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 23 + ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 15 + ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 12 + ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 15 (3 rows) select *,position('‘ÏÔ' in ‘Êõ‘Óï) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | position -----------------+-----------+----------+---------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 0 + ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | 3 ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | 0 ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | 0 (3 rows) @@ -161,9 +167,9 @@ select *,position(' select *,substring(‘Êõ‘Óï from 3 for 4) from ‘¼Æ‘Ë㑻ú‘Êõ‘Óï; ‘Êõ‘Óï | ‘·Ö‘Àà‘ºÅ | ‘±¸‘×¢1a | substring -----------------+-----------+----------+----------- - ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | ÄԑÏԑʾ - ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | Äԑͼ‘ÐÎ - ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | Äԑ³Ì‘Ðò + ‘µç‘ÄԑÏԑʾ‘ÆÁ | ‘»úA01‘ÉÏ | | ‘Ïԑʾ‘ÆÁ + ‘µç‘Äԑͼ‘ÐÎ | ‘·ÖB01‘ÖÐ | | ‘ͼ‘ÐÎ + ‘µç‘Äԑ³Ì‘Ðò‘Ô± | ‘ÈËZ01‘Ï | | ‘³Ì‘Ðò‘Ô± (3 rows) drop table “ͪ“ß©“Ѧ“¿ë“¾î; @@ -190,60 +196,67 @@ select * from (1 row) select * from “ͪ“ß©“Ѧ“¿ë“¾î where “Ý“׾“Äړµå ~* '“ìÑz01“ù»'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------+--------------+---------------- -(0 rows) + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ +--------------------------+--------------+---------------- + “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | +(1 row) select * from “ͪ“ß©“Ѧ“¿ë“¾î where “Ý“׾“Äړµå like '_Z01_'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------+--------------+---------------- -(0 rows) + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ +--------------------------+--------------+---------------- + “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | +(1 row) select * from “ͪ“ß©“Ѧ“¿ë“¾î where “Ý“׾“Äړµå like '_Z%'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------+--------------+---------------- -(0 rows) + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ +--------------------------+--------------+---------------- + “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | +(1 row) select * from “ͪ“ß©“Ѧ“¿ë“¾î where “¿ë“¾î ~ '“Äēǻ“ÅÍ[“µð“±×]'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------+--------------+---------------- -(0 rows) + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ +--------------------------+--------------+---------------- + “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | + “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | +(2 rows) select * from “ͪ“ß©“Ѧ“¿ë“¾î where “¿ë“¾î ~* '“Äēǻ“ÅÍ[“µð“±×]'; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ ---------+--------------+---------------- -(0 rows) + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ +--------------------------+--------------+---------------- + “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | + “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | +(2 rows) select *,character_length(“¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | char_length --------------------------+--------------+----------------+------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 12 - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 11 - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 12 + “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 8 + “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 7 + “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 8 (3 rows) select *,octet_length(“¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | octet_length --------------------------+--------------+----------------+-------------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 36 - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 32 - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 36 + “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 24 + “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 21 + “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 24 (3 rows) select *,position('“µð' in “¿ë“¾î) from “ͪ“ß©“Ѧ“¿ë“¾î; “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | position --------------------------+--------------+----------------+---------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 0 + “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | 4 “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | 0 “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | 0 (3 rows) select *,substring(“¿ë“¾î from 3 for 4) from “ͪ“ß©“Ѧ“¿ë“¾î; - “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | substring ---------------------------+--------------+----------------+----------- - “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | Ç»“Å͓µð - “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | Ç»“Å͓±× - “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | Ç»“Å͓ÇÁ + “¿ë“¾î | “Ý“׾“Äړµå | “ºñ“°í1a“¶ó“±¸ | substring +--------------------------+--------------+----------------+-------------- + “Äēǻ“Å͓µð“½º“ÇÓ·¹“ÀÌ | “ѦA01“ß¾ | | “Å͓µð“½º“Çà + “Äēǻ“Å͓±×“·¡“Çȓ½º | “ÝÂB10“ñé | | “Å͓±×“·¡“ÇÈ + “Äēǻ“Å͓ÇÁ“·Î“±×“·¡“¸Ó | “ìÑZ01“ù» | | “Å͓ÇÁ“·Î“±× (3 rows) drop table test; @@ -292,10 +305,10 @@ select *,octet_length(t) from test; t | octet_length --------------------------------------+-------------- ENGLISH | 7 - FRANÇAIS | 10 - ESPAÑOL | 9 - ÍSLENSKA | 10 - ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | 39 + FRANÇAIS | 9 + ESPAÑOL | 8 + ÍSLENSKA | 9 + ENGLISH FRANÇAIS ESPAÑOL ÍSLENSKA | 36 (5 rows) select *,position('L' in t) from test; diff --git a/src/test/mb/expected/unicode.out b/src/test/mb/expected/unicode.out index 71c9e9a441..b32ab76838 100644 --- a/src/test/mb/expected/unicode.out +++ b/src/test/mb/expected/unicode.out @@ -1,295 +1,87 @@ drop table 計算機用語; -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored -ERROR: table "è¨æ©èª" does not exist +ERROR: table "計算機用語" does not exist create table 計算機用語 (用語 text, 分類コード varchar, 備考1Aだよ char(16)); -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe582) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x99e8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8083) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe381) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa0e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8288) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "1" create index 計算機用語index1 on 計算機用語 using btree (用語); -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e69) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "btree" create index 計算機用語index2 on 計算機用語 using hash (分類コード); -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e69) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8929) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "hash" insert into 計算機用語 values('コンピュータディスプレイ','機A01上'); -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x87e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82a3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8397) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xace3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82a4) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9f41) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8a27) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "'" insert into 計算機用語 values('コンピュータグラフィックス','分B10中'); -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83a9) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x95e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82a3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82af) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xb927) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8642) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xad27) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "'" insert into 計算機用語 values('コンピュータプログラマー','人Z01下'); -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x97e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83ad) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83a9) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9ee3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xba5a) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8b27) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "'" vacuum 計算機用語; -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored -NOTICE: Vacuum: table not found select * from 計算機用語; -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored -ERROR: Relation 'è¨æ©èª' does not exist + 用語 | 分類コード | 備考1aだよ +-----------------------------------------+-----------------+---------------- + コンピュータディスプレイ | 機A01上 | + コンピュータグラフィックス | 分B10中 | + コンピュータプログラマー | 人Z01下 | +(3 rows) + select * from 計算機用語 where 分類コード = '人Z01下'; -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xba5a) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8b27) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "=" + 用語 | 分類コード | 備考1aだよ +--------------------------------------+-----------------+---------------- + コンピュータプログラマー | 人Z01下 | +(1 row) + select * from 計算機用語 where 分類コード ~* '人z01下'; -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xba7a) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8b27) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "~*" + 用語 | 分類コード | 備考1aだよ +--------------------------------------+-----------------+---------------- + コンピュータプログラマー | 人Z01下 | +(1 row) + select * from 計算機用語 where 分類コード like '_Z01_'; -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "'" + 用語 | 分類コード | 備考1aだよ +--------------------------------------+-----------------+---------------- + コンピュータプログラマー | 人Z01下 | +(1 row) + select * from 計算機用語 where 分類コード like '_Z%'; -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe588) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x86e9) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa19e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83bc) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8920) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "'" + 用語 | 分類コード | 備考1aだよ +--------------------------------------+-----------------+---------------- + コンピュータプログラマー | 人Z01下 | +(1 row) + select * from 計算機用語 where 用語 ~ 'コンピュータ[デグ]'; -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x87e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82b0) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "~" + 用語 | 分類コード | 備考1aだよ +-----------------------------------------+-----------------+---------------- + コンピュータディスプレイ | 機A01上 | + コンピュータグラフィックス | 分B10中 | +(2 rows) + select * from 計算機用語 where 用語 ~* 'コンピュータ[デグ]'; -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e20) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe382) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83b3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x83a5) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82bf) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x87e3) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x82b0) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "~*" + 用語 | 分類コード | 備考1aだよ +-----------------------------------------+-----------------+---------------- + コンピュータディスプレイ | 機A01上 | + コンピュータグラフィックス | 分B10中 | +(2 rows) + select *,character_length(用語) from 計算機用語; -NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored -ERROR: Relation 'è¨æ©èª' does not exist + 用語 | 分類コード | 備考1aだよ | char_length +-----------------------------------------+-----------------+----------------+------------- + コンピュータディスプレイ | 機A01上 | | 12 + コンピュータグラフィックス | 分B10中 | | 13 + コンピュータプログラマー | 人Z01下 | | 12 +(3 rows) + select *,octet_length(用語) from 計算機用語; -NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored -ERROR: Relation 'è¨æ©èª' does not exist + 用語 | 分類コード | 備考1aだよ | octet_length +-----------------------------------------+-----------------+----------------+-------------- + コンピュータディスプレイ | 機A01上 | | 36 + コンピュータグラフィックス | 分B10中 | | 39 + コンピュータプログラマー | 人Z01下 | | 36 +(3 rows) + select *,position('デ' in 用語) from 計算機用語; -NOTICE: local_to_utf: could not convert (0xe383) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x8727) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored -ERROR: Unterminated quoted string + 用語 | 分類コード | 備考1aだよ | position +-----------------------------------------+-----------------+----------------+---------- + コンピュータディスプレイ | 機A01上 | | 7 + コンピュータグラフィックス | 分B10中 | | 0 + コンピュータプログラマー | 人Z01下 | | 0 +(3 rows) + select *,substring(用語 from 10 for 4) from 計算機用語; -NOTICE: local_to_utf: could not convert (0xe794) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xa8e8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xaa9e) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x88e7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0xae97) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9fe7) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x94a8) EUC_JP to UTF-8. Ignored -NOTICE: local_to_utf: could not convert (0x9e3b) EUC_JP to UTF-8. Ignored -ERROR: parser: parse error at or near "from" + 用語 | 分類コード | 備考1aだよ | substring +-----------------------------------------+-----------------+----------------+-------------- + コンピュータディスプレイ | 機A01上 | | プレイ + コンピュータグラフィックス | 分B10中 | | ィックス + コンピュータプログラマー | 人Z01下 | | ラマー +(3 rows) + -- 2.40.0