"David Johnston" <polobo@xxxxxxxxx> writes: > PostgreSQL 9.1beta1, compiled by Visual C++ build 1500, 64-bit (EnterpriseDB > Install Executable) > CREATE DATABASE betatest > TEMPLATE template0 > ENCODING 'UTF8' > LC_COLLATE 'C' > LC_CTYPE 'C'; > CREATE DOMAIN idcode AS text > NOT NULL CHECK (VALUE ~* '^\w[-:\w]*$') > ; > SELECT 'AAAAAéaaaaa'::idcode; // -> SQL Error: ERROR: value for domain > idcode violates check constraint "idcode_check" (note the accented ?e? > between all the ?A?s) AFAICS that's correct behavior. C locale should not think that é is a letter. > This is running just fine against a 9.0 install on the same machine. We made some strides towards getting locale-sensitive stuff to work as it "should" in 9.1. In particular, platform-specific creative interpretations of what C locale means shouldn't happen anymore ... 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
