From: | dmigowski(at)ikoffice(dot)de |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #11523: Regular expressions work differently on different platforms |
Date: | 2014-09-30 09:56:25 |
Message-ID: | 20140930095625.7631.32436@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 11523
Logged by: Daniel Migowski
Email address: dmigowski(at)ikoffice(dot)de
PostgreSQL version: 9.1.2
Operating system: Debian Linux 6.0.6 + Windows 7
Description:
I recently found that regular expressions, or specifically the [:space:]
shorthand escape work differntly on Windows and Linux. On Linux the
non-brakeable space is not included in the shorthand escape, on windows it
is. The following statement is therefore true on Windows and false on
Linux:
select convert_from(E'\\xA0'::bytea,'ISO8859-1') ~ '\s'
This brakes email validation here, and the insert of a linux created backup
into my windows machine. Is it possible to fix that? Is there a reason that
utf-8 on Linux differs from utf-8 on Windows?
From | Date | Subject | |
---|---|---|---|
Next Message | feikesteenbergen | 2014-09-30 10:43:30 | BUG #11524: Unable to add value to ENUM when having AUTOCOMMIT disabled in psql |
Previous Message | Michael Paquier | 2014-09-30 08:04:48 | Re: BUG #11457: The below query crashes 9.3.5, but not 9.3.4 |