1 files changed, 333 insertions, 0 deletions
diff --git a/src/test/mb/expected/mule_internal.out b/src/test/mb/expected/mule_internal.out
new file mode 100644
index 0000000..ac8b57d
--- /dev/null
+++ b/src/test/mb/expected/mule_internal.out
@@ -0,0 +1,333 @@
+drop table ’·Ч’»»’µЎ’НС’ём;
+ERROR:  table "’·Ч’»»’µЎ’НС’ём" does not exist
+create table ’·Ч’»»’µЎ’НС’ём (’НС’ём text, ’К¬’Оа’Ґі’Ўј’ҐЙ varchar, ’Ич’№Н1A’¤А’¤и char(16));
+create index ’·Ч’»»’µЎ’НС’ёмindex1 on ’·Ч’»»’µЎ’НС’ём using btree (’НС’ём);
+create index ’·Ч’»»’µЎ’НС’ёмindex2 on ’·Ч’»»’µЎ’НС’ём using hash (’К¬’Оа’Ґі’Ўј’ҐЙ);
+insert into ’·Ч’»»’µЎ’НС’ём values('’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤','’µЎA01’ѕе');
+insert into ’·Ч’»»’µЎ’НС’ём values('’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№','’К¬B10’Гж');
+insert into ’·Ч’»»’µЎ’НС’ём values('’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј','’їНZ01’Іј');
+vacuum ’·Ч’»»’µЎ’НС’ём;
+select * from ’·Ч’»»’µЎ’НС’ём;
+            ’НС’ём            | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и 
+----------------------------+------------+------------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   | ’µЎA01’ѕе    | 
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№ | ’К¬B10’Гж    | 
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј   | ’їНZ01’Іј    | 
+(3 rows)
+
+select * from ’·Ч’»»’µЎ’НС’ём where ’К¬’Оа’Ґі’Ўј’ҐЙ = '’їНZ01’Іј';
+           ’НС’ём           | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и 
+--------------------------+------------+------------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј | ’їНZ01’Іј    | 
+(1 row)
+
+select * from ’·Ч’»»’µЎ’НС’ём where ’К¬’Оа’Ґі’Ўј’ҐЙ ~* '’їНz01’Іј';
+           ’НС’ём           | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и 
+--------------------------+------------+------------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј | ’їНZ01’Іј    | 
+(1 row)
+
+select * from ’·Ч’»»’µЎ’НС’ём where ’К¬’Оа’Ґі’Ўј’ҐЙ like '_Z01_';
+           ’НС’ём           | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и 
+--------------------------+------------+------------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј | ’їНZ01’Іј    | 
+(1 row)
+
+select * from ’·Ч’»»’µЎ’НС’ём where ’К¬’Оа’Ґі’Ўј’ҐЙ like '_Z%';
+           ’НС’ём           | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и 
+--------------------------+------------+------------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј | ’їНZ01’Іј    | 
+(1 row)
+
+select * from ’·Ч’»»’µЎ’НС’ём where ’НС’ём ~ '’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї[’ҐЗ’Ґ°]';
+            ’НС’ём            | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и 
+----------------------------+------------+------------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   | ’µЎA01’ѕе    | 
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№ | ’К¬B10’Гж    | 
+(2 rows)
+
+select * from ’·Ч’»»’µЎ’НС’ём where ’НС’ём ~* '’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї[’ҐЗ’Ґ°]';
+            ’НС’ём            | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и 
+----------------------------+------------+------------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   | ’µЎA01’ѕе    | 
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№ | ’К¬B10’Гж    | 
+(2 rows)
+
+select *,character_length(’НС’ём) from ’·Ч’»»’µЎ’НС’ём;
+            ’НС’ём            | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и | character_length 
+----------------------------+------------+------------+------------------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   | ’µЎA01’ѕе    |            |               12
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№ | ’К¬B10’Гж    |            |               13
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј   | ’їНZ01’Іј    |            |               12
+(3 rows)
+
+select *,octet_length(’НС’ём) from ’·Ч’»»’µЎ’НС’ём;
+            ’НС’ём            | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и | octet_length 
+----------------------------+------------+------------+--------------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   | ’µЎA01’ѕе    |            |           36
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№ | ’К¬B10’Гж    |            |           39
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј   | ’їНZ01’Іј    |            |           36
+(3 rows)
+
+select *,position('’ҐЗ' in ’НС’ём) from ’·Ч’»»’µЎ’НС’ём;
+            ’НС’ём            | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и | position 
+----------------------------+------------+------------+----------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   | ’µЎA01’ѕе    |            |        7
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№ | ’К¬B10’Гж    |            |        0
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј   | ’їНZ01’Іј    |            |        0
+(3 rows)
+
+select *,substring(’НС’ём from 10 for 4) from ’·Ч’»»’µЎ’НС’ём;
+            ’НС’ём            | ’К¬’Оа’Ґі’Ўј’ҐЙ | ’Ич’№Н1a’¤А’¤и | substring 
+----------------------------+------------+------------+-----------
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЗ’ҐЈ’Ґ№’ҐЧ’Ґм’Ґ¤   | ’µЎA01’ѕе    |            | ’ҐЧ’Ґм’Ґ¤
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’Ґ°’Ґй’ҐХ’ҐЈ’ҐГ’ҐЇ’Ґ№ | ’К¬B10’Гж    |            | ’ҐЈ’ҐГ’ҐЇ’Ґ№
+ ’Ґі’Ґу’ҐФ’Ґе’Ўј’Ґї’ҐЧ’Ґн’Ґ°’Ґй’ҐЮ’Ўј   | ’їНZ01’Іј    |            | ’Ґй’ҐЮ’Ўј
+(3 rows)
+
+drop table ‘јЖ‘Лг‘»ъ‘Кх‘Уп;
+ERROR:  table "‘јЖ‘Лг‘»ъ‘Кх‘Уп" does not exist
+create table ‘јЖ‘Лг‘»ъ‘Кх‘Уп(‘Кх‘Уп text, ‘·Ц‘Аа‘єЕ varchar, ‘±ё‘Чў1A char(16));
+create index ‘јЖ‘Лг‘»ъ‘Кх‘Упindex1 on ‘јЖ‘Лг‘»ъ‘Кх‘Уп using btree(‘Кх‘Уп);
+create index ‘јЖ‘Лг‘»ъ‘Кх‘Упindex2 on ‘јЖ‘Лг‘»ъ‘Кх‘Уп using btree(‘·Ц‘Аа‘єЕ);
+insert into ‘јЖ‘Лг‘»ъ‘Кх‘Уп values('‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ','‘»ъA01‘ЙП');
+insert into ‘јЖ‘Лг‘»ъ‘Кх‘Уп values('‘µз‘ДФ‘Нј‘РО','‘·ЦB01‘ЦР');
+insert into ‘јЖ‘Лг‘»ъ‘Кх‘Уп values('‘µз‘ДФ‘іМ‘Рт‘Ф±','‘ИЛZ01‘ПВ');
+vacuum ‘јЖ‘Лг‘»ъ‘Кх‘Уп;
+select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп;
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a 
+------------+---------+--------
+ ‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ | ‘»ъA01‘ЙП | 
+ ‘µз‘ДФ‘Нј‘РО   | ‘·ЦB01‘ЦР | 
+ ‘µз‘ДФ‘іМ‘Рт‘Ф± | ‘ИЛZ01‘ПВ | 
+(3 rows)
+
+select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘·Ц‘Аа‘єЕ = '‘ИЛZ01‘ПВ';
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a 
+------------+---------+--------
+ ‘µз‘ДФ‘іМ‘Рт‘Ф± | ‘ИЛZ01‘ПВ | 
+(1 row)
+
+select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘·Ц‘Аа‘єЕ ~* '‘ИЛz01‘ПВ';
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a 
+------------+---------+--------
+ ‘µз‘ДФ‘іМ‘Рт‘Ф± | ‘ИЛZ01‘ПВ | 
+(1 row)
+
+select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘·Ц‘Аа‘єЕ like '_Z01_';
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a 
+------------+---------+--------
+ ‘µз‘ДФ‘іМ‘Рт‘Ф± | ‘ИЛZ01‘ПВ | 
+(1 row)
+
+select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘·Ц‘Аа‘єЕ like '_Z%';
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a 
+------------+---------+--------
+ ‘µз‘ДФ‘іМ‘Рт‘Ф± | ‘ИЛZ01‘ПВ | 
+(1 row)
+
+select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘Кх‘Уп ~ '‘µз‘ДФ[‘ПФ‘Нј]';
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a 
+------------+---------+--------
+ ‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ | ‘»ъA01‘ЙП | 
+ ‘µз‘ДФ‘Нј‘РО   | ‘·ЦB01‘ЦР | 
+(2 rows)
+
+select * from ‘јЖ‘Лг‘»ъ‘Кх‘Уп where ‘Кх‘Уп ~* '‘µз‘ДФ[‘ПФ‘Нј]';
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a 
+------------+---------+--------
+ ‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ | ‘»ъA01‘ЙП | 
+ ‘µз‘ДФ‘Нј‘РО   | ‘·ЦB01‘ЦР | 
+(2 rows)
+
+select *,character_length(‘Кх‘Уп) from ‘јЖ‘Лг‘»ъ‘Кх‘Уп;
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a | character_length 
+------------+---------+--------+------------------
+ ‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ | ‘»ъA01‘ЙП |        |                5
+ ‘µз‘ДФ‘Нј‘РО   | ‘·ЦB01‘ЦР |        |                4
+ ‘µз‘ДФ‘іМ‘Рт‘Ф± | ‘ИЛZ01‘ПВ |        |                5
+(3 rows)
+
+select *,octet_length(‘Кх‘Уп) from ‘јЖ‘Лг‘»ъ‘Кх‘Уп;
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a | octet_length 
+------------+---------+--------+--------------
+ ‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ | ‘»ъA01‘ЙП |        |           15
+ ‘µз‘ДФ‘Нј‘РО   | ‘·ЦB01‘ЦР |        |           12
+ ‘µз‘ДФ‘іМ‘Рт‘Ф± | ‘ИЛZ01‘ПВ |        |           15
+(3 rows)
+
+select *,position('‘ПФ' in ‘Кх‘Уп) from ‘јЖ‘Лг‘»ъ‘Кх‘Уп;
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a | position 
+------------+---------+--------+----------
+ ‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ | ‘»ъA01‘ЙП |        |        3
+ ‘µз‘ДФ‘Нј‘РО   | ‘·ЦB01‘ЦР |        |        0
+ ‘µз‘ДФ‘іМ‘Рт‘Ф± | ‘ИЛZ01‘ПВ |        |        0
+(3 rows)
+
+select *,substring(‘Кх‘Уп from 3 for 4) from ‘јЖ‘Лг‘»ъ‘Кх‘Уп;
+    ‘Кх‘Уп    | ‘·Ц‘Аа‘єЕ  | ‘±ё‘Чў1a | substring 
+------------+---------+--------+-----------
+ ‘µз‘ДФ‘ПФ‘Кѕ‘ЖБ | ‘»ъA01‘ЙП |        | ‘ПФ‘Кѕ‘ЖБ
+ ‘µз‘ДФ‘Нј‘РО   | ‘·ЦB01‘ЦР |        | ‘Нј‘РО
+ ‘µз‘ДФ‘іМ‘Рт‘Ф± | ‘ИЛZ01‘ПВ |        | ‘іМ‘Рт‘Ф±
+(3 rows)
+
+drop table “НЄ“Я©“С¦“їл“ѕо;
+ERROR:  table "“НЄ“Я©“С¦“їл“ѕо" does not exist
+create table “НЄ“Я©“С¦“їл“ѕо (“їл“ѕо text, “ЭВ“Чѕ“ДЪ“µе varchar, “єс“°н1A“¶у“±ё char(16));
+create index “НЄ“Я©“С¦“їл“ѕоindex1 on “НЄ“Я©“С¦“їл“ѕо using btree (“їл“ѕо);
+create index “НЄ“Я©“С¦“їл“ѕоindex2 on “НЄ“Я©“С¦“їл“ѕо using hash (“ЭВ“Чѕ“ДЪ“µе);
+insert into “НЄ“Я©“С¦“їл“ѕо values('“ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ', '“С¦A01“Яѕ');
+insert into “НЄ“Я©“С¦“їл“ѕо values('“ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє', '“ЭВB10“сй');
+insert into “НЄ“Я©“С¦“їл“ѕо values('“ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ', '“мСZ01“щ»');
+vacuum “НЄ“Я©“С¦“їл“ѕо;
+select * from “НЄ“Я©“С¦“їл“ѕо;
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё 
+------------------+----------+------------
+ “ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ | “С¦A01“Яѕ  | 
+ “ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   | “ЭВB10“сй  | 
+ “ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ | “мСZ01“щ»  | 
+(3 rows)
+
+select * from “НЄ“Я©“С¦“їл“ѕо where “ЭВ“Чѕ“ДЪ“µе = '“мСZ01“щ»';
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё 
+------------------+----------+------------
+ “ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ | “мСZ01“щ»  | 
+(1 row)
+
+select * from “НЄ“Я©“С¦“їл“ѕо where “ЭВ“Чѕ“ДЪ“µе ~* '“мСz01“щ»';
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё 
+------------------+----------+------------
+ “ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ | “мСZ01“щ»  | 
+(1 row)
+
+select * from “НЄ“Я©“С¦“їл“ѕо where “ЭВ“Чѕ“ДЪ“µе like '_Z01_';
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё 
+------------------+----------+------------
+ “ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ | “мСZ01“щ»  | 
+(1 row)
+
+select * from “НЄ“Я©“С¦“їл“ѕо where “ЭВ“Чѕ“ДЪ“µе like '_Z%';
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё 
+------------------+----------+------------
+ “ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ | “мСZ01“щ»  | 
+(1 row)
+
+select * from “НЄ“Я©“С¦“їл“ѕо where “їл“ѕо ~ '“ДД“З»“ЕН[“µр“±Ч]';
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё 
+------------------+----------+------------
+ “ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ | “С¦A01“Яѕ  | 
+ “ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   | “ЭВB10“сй  | 
+(2 rows)
+
+select * from “НЄ“Я©“С¦“їл“ѕо where “їл“ѕо ~* '“ДД“З»“ЕН[“µр“±Ч]';
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё 
+------------------+----------+------------
+ “ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ | “С¦A01“Яѕ  | 
+ “ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   | “ЭВB10“сй  | 
+(2 rows)
+
+select *,character_length(“їл“ѕо) from “НЄ“Я©“С¦“їл“ѕо;
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё | character_length 
+------------------+----------+------------+------------------
+ “ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ | “С¦A01“Яѕ  |            |                8
+ “ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   | “ЭВB10“сй  |            |                7
+ “ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ | “мСZ01“щ»  |            |                8
+(3 rows)
+
+select *,octet_length(“їл“ѕо) from “НЄ“Я©“С¦“їл“ѕо;
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё | octet_length 
+------------------+----------+------------+--------------
+ “ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ | “С¦A01“Яѕ  |            |           24
+ “ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   | “ЭВB10“сй  |            |           21
+ “ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ | “мСZ01“щ»  |            |           24
+(3 rows)
+
+select *,position('“µр' in “їл“ѕо) from “НЄ“Я©“С¦“їл“ѕо;
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё | position 
+------------------+----------+------------+----------
+ “ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ | “С¦A01“Яѕ  |            |        4
+ “ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   | “ЭВB10“сй  |            |        0
+ “ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ | “мСZ01“щ»  |            |        0
+(3 rows)
+
+select *,substring(“їл“ѕо from 3 for 4) from “НЄ“Я©“С¦“їл“ѕо;
+       “їл“ѕо       | “ЭВ“Чѕ“ДЪ“µе | “єс“°н1a“¶у“±ё | substring 
+------------------+----------+------------+-----------
+ “ДД“З»“ЕН“µр“Ѕє“ЗГ“·№“АМ | “С¦A01“Яѕ  |            | “ЕН“µр“Ѕє“ЗГ
+ “ДД“З»“ЕН“±Ч“·Ў“ЗИ“Ѕє   | “ЭВB10“сй  |            | “ЕН“±Ч“·Ў“ЗИ
+ “ДД“З»“ЕН“ЗБ“·О“±Ч“·Ў“ёУ | “мСZ01“щ»  |            | “ЕН“ЗБ“·О“±Ч
+(3 rows)
+
+drop table test;
+ERROR:  table "test" does not exist
+create table test (t text);
+insert into test values('ENGLISH');
+insert into test values('FRANЃЗAIS');
+insert into test values('ESPAЃСOL');
+insert into test values('ЃНSLENSKA');
+insert into test values('ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA');
+vacuum test;
+select * from test;
+                 t                 
+-----------------------------------
+ ENGLISH
+ FRANЃЗAIS
+ ESPAЃСOL
+ ЃНSLENSKA
+ ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA
+(5 rows)
+
+select * from test where t = 'ESPAЃСOL';
+    t    
+---------
+ ESPAЃСOL
+(1 row)
+
+select * from test where t ~* 'espaЃСol';
+                 t                 
+-----------------------------------
+ ESPAЃСOL
+ ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA
+(2 rows)
+
+select *,character_length(t) from test;
+                 t                 | character_length 
+-----------------------------------+------------------
+ ENGLISH                           |                7
+ FRANЃЗAIS                          |                8
+ ESPAЃСOL                           |                7
+ ЃНSLENSKA                          |                8
+ ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA |               33
+(5 rows)
+
+select *,octet_length(t) from test;
+                 t                 | octet_length 
+-----------------------------------+--------------
+ ENGLISH                           |            7
+ FRANЃЗAIS                          |            9
+ ESPAЃСOL                           |            8
+ ЃНSLENSKA                          |            9
+ ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA |           36
+(5 rows)
+
+select *,position('L' in t) from test;
+                 t                 | position 
+-----------------------------------+----------
+ ENGLISH                           |        4
+ FRANЃЗAIS                          |        0
+ ESPAЃСOL                           |        7
+ ЃНSLENSKA                          |        3
+ ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA |        4
+(5 rows)
+
+select *,substring(t from 3 for 4) from test;
+                 t                 | substring 
+-----------------------------------+-----------
+ ENGLISH                           | GLIS
+ FRANЃЗAIS                          | ANЃЗA
+ ESPAЃСOL                           | PAЃСO
+ ЃНSLENSKA                          | LENS
+ ENGLISH FRANЃЗAIS ESPAЃСOL ЃНSLENSKA | GLIS
+(5 rows)
+