Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group