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

BUG #4890: Allow insert character has no equivalent in "LATIN2"

From: "saint" <saint(at)akpa(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4890: Allow insert character has no equivalent in "LATIN2"
Date: 2009-06-27 19:20:21
Message-ID: 200906271920.n5RJKLeP003771@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4890
Logged by:          saint
Email address:      saint(at)akpa(dot)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.

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-06-28 04:32:33
Subject: Re: BUG #4875: /etc/init.d/postgresql status shows postmaster is stopped when executed as user
Previous:From: RicardoDate: 2009-06-27 12:06:30
Subject: BUG #4889: Accent Sensitive

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