Re: PLEASE: I really need german characters - Mailing list pgsql-odbc

I recreated the whole database, personnally, yes. That's the best thing to do, I think.

Philippe Lang

-----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 13:35
À : Pgsql-Odbc (E-Mail)
Objet : Re: [ODBC] PLEASE: I really need german characters


How do i do that?
Shall i make a dump of the database?
Recreate the database with: createdb -E LATIN1 database
and put the dump back to the database?
Do you have something in your ConnectString in the ODBC Driver on page 2 of the datasource?
Gunnar


-----Ursprüngliche Nachricht-----
Von: Philippe Lang [mailto:philippe.lang@attiksystem.ch]
Gesendet: Donnerstag, 4. Dezember 2003 13:28
An: Gunnar Groetschel; Pgsql-Odbc (E-Mail)
Betreff: RE: [ODBC] PLEASE: I really need german characters


You have to encode the database in Latin1... It works perfectly with the latest driver.

-----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 12:35
À : Pgsql-Odbc (E-Mail)
Objet : Re: [ODBC] PLEASE: I really need german characters


Nothing worked.
I have now tried a few things and nothing helped.

There must be a bug in the ODBC Driver!!!

If i use PGAdmin III to connect to the database i see "Umlaute" (=äöüÄÖÜ) CORRECT!
If i use the odbc driver i see only sh** (Möller should be Müller).
If i use psql on my linux box, i also can see all the (Umlaute) correct.
psql -l shows me, that the database is in SQL_ASCII (what should be ok - after 2 hours reading manual pages).

I have tried to encode the database in Latin9, Latin2, Windows1256 and unicode - didn't help
I have compiled the new 7.4 database - didn't help
I have set the clien_encoding parameter in postgres.conf - didn't help
I have written a VB Script (you can see it above) to access the database - didn't help

I am really +*++a#? with this sh*** odbc driver :-))

Best regards
Gunnar

############################
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
conn.ConnectionString =
"DRIVER={PostgreSQL};SERVER=192.168.1.117;DATABASE=ixkaizen_import;PORT=5432;UID=postgres;CONNSETTINGS=SET
CLIENT_ENCODINGTO 'LATIN9';" 
conn.Open
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open "select str_name from xcrm_contactb0d6d496 where str_name like 'M%'", conn, adOpenDynamic, adLockOptimistic
Do While Not rs.EOF
    Debug.Print rs!str_name
rs.MoveNext
Loop

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match