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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

MULE_INTERNAL translation to win1250




Hi.

I have a strange problem in postgres 8.1.4 (gentoo 64bit on AMD64 platform)

My database is created vith LATIN-2 encoding for correct vieving of nacional specific characters ( czech language )

inside code of my php application is setting client encoding to win1250 because I need output of query in this encoding.

On some parts of data I got an error :

Query failed: ERROR: character 0x829a of encoding "MULE_INTERNAL" has no equivalent in "WIN1250"

Without "set client_encoding to win1250" query works. I am curious why there is a MULE_INTERNAL mentioned even when \l+ say that corresponding database is created with (and even all the cluster) LATIN2 encoding.

Strange enough that ALL INSERTS are done with WIN1250 client encoding too. May be a bug in charset translation routines of postgres ?




And how can I  repair it, preferable in whole  database ?


Thanx for help.









Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group