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: (view raw, whole thread or download thread mbox)
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


pgsql-general by date

Next:From: salah jubehDate: 2011-05-31 20:42:16
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-2017 The PostgreSQL Global Development Group