Home > mailing lists

UTF-8 and Regular expression - Mailing list pgsql-general

From	Håvard Wahl Kongsgård
Subject	UTF-8 and Regular expression
Date	May 31, 2011 20:42:17
Msg-id	BANLkTinQ-qiHPCQ4Tp1ML9YPs=dqOb1OyA@mail.gmail.com Whole thread Raw
Responses	Re: UTF-8 and Regular expression (Tom Lane <tgl@sss.pgh.pa.us>)
List	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 ü ø æ å

From: Tom Lane
Date: 31 May 2011, 20:28:28
Subject: Re: Function Column Expansion Causes Inserts To Fail

From: salah jubeh
Date: 31 May 2011, 20:42:26
Subject: PG_RESTORE