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

Поиск
Список
Период
Сортировка
От Marius Žalinauskas
Тема BUG #2535: Unicode on Windows: aogonek is not distinguished from agrave
Дата
Msg-id 200607180706.k6I76AW5024064@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2535: Unicode on Windows: aogonek is not distinguished from agrave  (Marius Žalinauskas <mariusz@splius.lt>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2535
Logged by:          Marius Žalinauskas
Email address:      mariusz@splius.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 ('À');

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "John Lyssy"
Дата:
Сообщение: BUG #2538: Hang on insert/select
Следующее
От: Tom Lane
Дата:
Сообщение: Re: double insert on inherited table with where constraint based on sequence