Susannah <cyclingrelf@gmail.com> wrote:
> FATAL: conversion between WIN1252 and LATIN1 is not supported
WIN1512 supports characters which are not supported by LATIN1. If
you sent such characters to the database, what would you expect to
happen?
> I can connect through pgAdmin and create tables etc, just not with
> psql.
Perhaps pgAdmin detects the mismatch and sets the client-side
character set to the more limited LATIN1? What does pgAdmin do if
you make such a connection and then try to store a character which
is not in the LATIN1 character set, like a euro character?
-Kevin