Support of multibyte encoding for pg_trgm
От | Brian Hirt |
---|---|
Тема | Support of multibyte encoding for pg_trgm |
Дата | |
Msg-id | 4DB2B240-3BFD-4886-8A70-5F27A807FACC@mobygames.com обсуждение исходный текст |
Список | pgsql-general |
Teodor, I ran across a commit message that shows multibyte encoding support in 8.4 and my testing shows that to be the case as well. Is there a back patch for 8.2? My own quick attempt at creating one didn't work so well and before I start spending some major time trying I thought I'd check in with you. Regards, Brian Hirt Postgres Version 8.2 and 8.3 test=# select show_trgm('魔法門英雄無敵2:王位爭奪戰'); show_trgm --------------- {" 2"," 2 "} (1 row) Postgres Version 8.4 test=# select show_trgm('魔法門英雄無敵2:王位爭奪戰'); show_trgm ------------------------------------------------------------------------------------------------------------------------------------------ {0x84af82,0x8426fb,0x886567,0x8986ec, 0x8c3de8,0x9c19f5,0xa0ef88,0xae352c,0xc7de23,0xf449ca, 0x003dc9,0x1003c8,0x143838,0x64a38f,0x650b2a} (1 row) Log Message: ----------- Support of multibyte encoding for pg_trgm Modified Files: -------------- pgsql/contrib/pg_trgm: trgm.h (r1.9 -> r1.10) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_trgm/trgm.h?r1=1.9&r2=1.10 ) trgm_gin.c (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_trgm/trgm_gin.c?r1=1.5&r2=1.6 ) trgm_op.c (r1.10 -> r1.11) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_trgm/trgm_op.c?r1=1.10&r2=1.11 )
В списке pgsql-general по дате отправления: