UTF-8 and Regular expression

From: Håvard Wahl Kongsgård <haavard(dot)kongsgaard(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: UTF-8 and Regular expression
Date: 2011-05-31 20:42:10
Message-ID: BANLkTinQ-qiHPCQ4Tp1ML9YPs=dqOb1OyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, in 8.4 how does the regular expression functions in postgresql handle
special UTF-8 characters?

for example:
SELECT name,substring(name from E'\\w+\\s(\\w+)$') from nodes;
fails to select characters like ü ø æ å

--
Håvard Wahl Kongsgård

http://havard.security-review.net/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message salah jubeh 2011-05-31 20:42:16 PG_RESTORE
Previous Message Tom Lane 2011-05-31 20:28:15 Re: Function Column Expansion Causes Inserts To Fail