Re: [GENERAL] UTF-8 and Regular expression

2011-05-31 Thread Tom Lane
=?ISO-8859-1?Q?H=E5vard_Wahl_Kongsg=E5rd?= writes: > Hi, in 8.4 how does the regular expression functions in postgresql handle > special UTF-8 characters? Badly :-( > for example: > SELECT name,substring(name from E'\\w+\\s(\\w+)$') from nodes; > fails to select characters like ü ø æ å Should

[GENERAL] UTF-8 and Regular expression

2011-05-31 Thread Håvard Wahl Kongsgård
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/