Skip site navigation (1) Skip section navigation (2)

BUG #2535: Unicode on Windows: aogonek is not distinguished from agrave

From: "Marius alinauskas" <mariusz(at)splius(dot)lt>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2535: Unicode on Windows: aogonek is not distinguished from agrave
Date: 2006-07-18 07:06:10
Message-ID: 200607180706.k6I76AW5024064@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2535
Logged by:          Marius alinauskas
Email address:      mariusz(at)splius(dot)lt
PostgreSQL version: 8.1.4
Operating system:   Windows XP Pro
Description:        Unicode on Windows: aogonek is not distinguished from
agrave
Details: 

It seems that on Windows PostgreSQL v8.1.4 does not distinguish aogonek
(U+0104, U+0105) from agrave (U+00C0, U+00E0):

CREATE DATABASE tests ENCODING = 'UTF8';

\c tests

CREATE TABLE foo
(
  bar char(1) PRIMARY KEY
);

-- OK
INSERT INTO foo (bar) VALUES ('');

-- ERROR: duplicate key violates unique constraint
INSERT INTO foo (bar) VALUES ('');

-- Same thing with capitals

-- OK
INSERT INTO foo (bar) VALUES ('');

-- ERROR: duplicate key violates unique constraint
INSERT INTO foo (bar) VALUES ('');


Responses

pgsql-bugs by date

Next:From: Alexandr SeredaDate: 2006-07-18 07:41:45
Subject: BUG #2536: TInterval: wrong interpretation of "Undefined Range" value.
Previous:From: SudhakarDate: 2006-07-17 11:51:33
Subject: BUG #2534: ERROR: invalid memory alloc request size 4294967293

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group