=?ISO-8859-1?Q?H=E5vard_Wahl_Kongsg=E5rd?= <haavard.kongsgaard@xxxxxxxxx> 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 work in 9.0, but no chance in earlier releases. You need to use a single-byte encoding such as LATIN1 if you need to do this in older releases. In any release, make sure you're using an LC_COLLATE setting that's appropriate for the language and encoding. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
