Re: PLEASE: I really need german characters

Gunnar,

1. pg_dump dbname > backup_dump_file

2. Drop your database

3. CREATE DATABASE dbname WITH ENCODING = 'LATIN1'

4. psql dbname < backup_dump_file


That's all!

Philippe


-----Message d'origine-----
De : pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org]De la part de Gunnar Groetschel
Envoyé : jeudi, 4. décembre 2003 17:24
À : Pgsql-Odbc (E-Mail)
Objet : Re: [ODBC] PLEASE: I really need german characters


Thanks very much for your help.
You are right its UTF-8.
I have tried all "SET CLIENT_ENCODING TO '*'" but nothin worked.
There is an error and i don't find it.
PGAdmin III (also on Windows) works fine so i am testing now what encoding PGAdmin III is using.
I have set up the debugging and PGAdmin says that it is using the SQL_ASCII encoding. All the Umlauts are there. This
isreally curious.  
I am too tired to find the error today and go home now.
Thanks for any help
Best regards
Gunnar



-----Ursprüngliche Nachricht-----
Von: Benjamin Riefenstahl [mailto:Benjamin.Riefenstahl@epost.de]
Gesendet: Donnerstag, 4. Dezember 2003 15:37
An: Gunnar Groetschel
Cc: Pgsql-Odbc (E-Mail)
Betreff: Re: PLEASE: I really need german characters


Hi Gunnar,


"Gunnar Groetschel" <ggroetschel@sokoma.de> writes:
> If i use the odbc driver i see only sh** (Möller should be Müller).

That looks like UTF-8.

> psql -l shows me, that the database is in SQL_ASCII (what should be
> ok - after 2 hours reading manual pages).

I haven't read the manual for this, but strictly speaking "ASCII"
means, that you don't have umlauts at all, or rather that their
encoding is undefined.  Which is not good for a stable database,
because with any update of any tool, that tool can change its internal
default interpretation and potentially start corrupting data.  You
really do want a database encoding that supports your data explicitly.

Some ODBC-based tools let you configure how to encode data going in
and out of the ODBC API.  Also in the past I have had success with
issuing

  SET CLIENT_ENCODING TO 'UNICODE'

on the connection once to get the data in UTF-8.  You may want to see,
if a similar statement can be used to change the DB interface encoding
to Latin-1 or Windows-1252.


benny


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org