/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/hstore/sql/hstore_utf8.sql
26 строк
855 B
Michael Paquier
Handle \v as a whitespace character in parsers
06 июл 2023, 02:16
06 июл 2023, 02:16
ae6d06f
Код
Авторство
О чём код?
/* * This test must be run in a database with UTF-8 encoding, * because other encodings don't support all the characters used. */ SELECT getdatabaseencoding() <> 'UTF8' AS skip_test \gset \if :skip_test \quit \endif SET client_encoding = utf8; -- UTF-8 locale bug on macOS: isspace(0x85) returns true. \u0105 encodes -- as 0xc4 0x85 in UTF-8; the 0x85 was interpreted here as a whitespace. SELECT E'key\u0105=>value\u0105'::hstore; SELECT 'keyą=>valueą'::hstore; SELECT 'ą=>ą'::hstore; SELECT 'keyąfoo=>valueą'::hstore; -- More patterns that may depend on isspace() and locales, all discarded. SELECT E'key\u000A=>value\u000A'::hstore; -- \n SELECT E'key\u0009=>value\u0009'::hstore; -- \t SELECT E'key\u000D=>value\u000D'::hstore; -- \r SELECT E'key\u000B=>value\u000B'::hstore; -- \v SELECT E'key\u000C=>value\u000C'::hstore; -- \f