> If I setup the database as follows: > LANG=C > initdb -E iso8859_1 > createdb -E iso8859_1 > > Then it appears to work OK - but I then get an error with character 0xE2 > (Latin small letter a with circumflex): > ERROR: could not convert UTF-8 character 0x00e2 to ISO8859-1 The error message says all. You are trying to convert an UTF-8 character starting with 0x00e2 to ISO-8859-1, which does not exist in the world. All ISO-8859-1 chars in UTF-8 are below 0x00e0 range. Probably you mixed up with ISO-8859-2 or any other characters other than ISO-8859-1? -- Tatsuo Ishii ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)