Postgres Pro
Downloads
Home   >   mailing lists

`pg_trgm` not recognizing Chinese characters in macOS - Mailing list pgsql-bugs

From Haotian Yang
Subject `pg_trgm` not recognizing Chinese characters in macOS
Date
Msg-id BN6PR18MB09323CCBF288EF650DCCF9E8AB040@BN6PR18MB0932.namprd18.prod.outlook.com
Whole thread Raw
Responses Re: `pg_trgm` not recognizing Chinese characters in macOS  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
Versions: macOS 10.13.6, PostgreSQL 10.5, pg_trgm 1.3.
LC_ALL=en_US.UTF-8

reproduce:
- enter psql as admin.
- `CREATE EXTENSION pg_trgm`.
- `SELECT show_trgm(‘一个句子’)`.

expects:
- something like `{0x…,0x…}`

gets:
- `{}`

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #15376: Postgres sql 9.4.19 pg_upgrade stops with error Thesource cluster was not shut down cleanly.
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #15378: SP-GIST memory context screwup?