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.