Postgres Pro
Downloads
Home   >   mailing lists

BUG #4890: Allow insert character has no equivalent in "LATIN2" - Mailing list pgsql-bugs

From saint
Subject BUG #4890: Allow insert character has no equivalent in "LATIN2"
Date
Msg-id 200906271920.n5RJKLeP003771@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4890: Allow insert character has no equivalent in "LATIN2"  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      4890
Logged by:          saint
Email address:      saint@akpa.pl
PostgreSQL version: 8.4 RC1
Operating system:   Windows XP
Description:        Allow insert character has no equivalent in "LATIN2"
Details:

Database encoding: "LATIN2"

set client_encoding to 'UTF8';
insert into public.test(col) values('‰');

ERROR: character 0xe280b0 of encoding "UTF8" has no equivalent in "LATIN2"

in this case is correct but if client_encoding is 'WIN1250':

set client_encoding to 'WIN1250';
insert into public.test(col) values('‰');

Query returned successfully: 1 row affected, 0 ms execution time.

pgsql-bugs by date:

Previous
From: "Ricardo"
Date:
Subject: BUG #4889: Accent Sensitive
Next
From: "Armin Jenewein"
Date:
Subject: BUG #4875: /etc/init.d/postgresql status shows postmaster is stopped when executed as user