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(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)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 is really 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(dot)Riefenstahl(at)epost(dot)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(at)sokoma(dot)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(at)postgresql(dot)org