Skip site navigation (1) Skip section navigation (2)

codepage

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: pgsql-odbc(at)postgresql(dot)org
Subject: codepage
Date: 2006-04-26 17:29:40
Message-ID: 20060426172940.GE8051@quartz.itdept.newn.cam.ac.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
I came across the traditional

ERROR:  conversion between latin9 and LATIN1 is not supported

and read the thread latin1/latin9 in this list. The underlying
answer is essentially

http://www.postgresql.org/docs/8.1/static/multibyte.html#AEN22506

iso_8859_1_to_utf8 exists, and utf8_to_iso_8859_15 exists but not
iso_8859_1_to_8859_15, and "create conversion" as the documentation
page suggests might help.

But(!) I then wondered where the latin9 came from, and it seems to be
from:

                        case 1252:       
                                if (PG_VERSION_GE(self, 7.2))    
                                        wenc = "latin9";         
                                else     
                                        wenc = "latin1";         
                                break;   

in multibyte.c. (I'm looking at psqlodbc-08.01.0200 and running 8.2devel)

Why latin9? WIN1252 does exist (not sure when it was created - 8.1 same
as WIN1251?)

Cheers,

Patrick

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-04-26 17:37:59
Subject: Re: Problem with the PGSQL-ODBC driver and MS Access
Previous:From: noreplyDate: 2006-04-26 17:24:48
Subject: [ psqlodbc-Bugs-1000620 ] SQLStatistics returns UNKNOWN instead of real column names

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group