Обсуждение: SQL_ASCII charset conversion
Hi we have a Postgres 8.4 database with SQL_ASCII encoding. Unfortunately, there are non ascii characters stored in this database. The encoding used to store the non-ascii characters was ISO-8859-1 (LATIN1). I know thats not the way to go, but thats the situation. With the old Postgres JDBC Driver (older than 7.2), the charSet Property could be as follows: charSet=ISO-8859-1 With this setting, the characers in the database are correctly interpreted. Now, with the new 8.4 postgres JDBC driver, this charSet setting is not supported anymore. How can I set the character encoding to ISO-8859-1 in the 8.4 Postgres Driver? Thank you very much. Regards Dieter -- View this message in context: http://postgresql.1045698.n5.nabble.com/SQL-ASCII-charset-conversion-tp4733958p4733958.html Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.
Hi, I bearly looked at driver code, and I see setting charSet is possible only if databse is 7.3 or earlier. I think better solution will bo for you to dump databse to sql, and eventually fix encoding with iconv. You may try to set system encoding /in Your session/ to ASCII or better to ISO-8859-1 and take dump, then create database with proper encoding (or change database creation to reflex desired encodind in dumped file). If you will restore database from such file, and such session everything should work. I hope. Regards, Dieter <dieter.salathe@syslink.ch> Thursday 25 of August 2011 12:41:44 > Hi > > we have a Postgres 8.4 database with SQL_ASCII encoding. > > Unfortunately, there are non ascii characters stored in this database. The > encoding used to store the non-ascii characters was ISO-8859-1 (LATIN1). I > know thats not the way to go, but thats the situation. > > > With the old Postgres JDBC Driver (older than 7.2), the charSet Property > could be as follows: > charSet=ISO-8859-1 > With this setting, the characers in the database are correctly interpreted. > > Now, with the new 8.4 postgres JDBC driver, this charSet setting is not > supported anymore. > How can I set the character encoding to ISO-8859-1 in the 8.4 Postgres > Driver? > > Thank you very much. > > Regards > Dieter > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/SQL-ASCII-charset-conversion-tp473 > 3958p4733958.html Sent from the PostgreSQL - jdbc mailing list archive at > Nabble.com.
Hi, I bearly looked at driver code, and I see setting charSet is possible only if databse is 7.3 or earlier. I think better solution will bo for you to dump databse to sql, and eventually fix encoding with iconv. You may try to set system encoding /in Your session/ to ASCII or better to ISO-8859-1 and take dump, then create database with proper encoding (or change database creation to reflex desired encodind in dumped file). If you will restore database from such file, and such session everything should work. I hope. Regards, Dieter <dieter.salathe@syslink.ch> Thursday 25 of August 2011 12:41:44 > Hi > > we have a Postgres 8.4 database with SQL_ASCII encoding. > > Unfortunately, there are non ascii characters stored in this database. The > encoding used to store the non-ascii characters was ISO-8859-1 (LATIN1). I > know thats not the way to go, but thats the situation. > > > With the old Postgres JDBC Driver (older than 7.2), the charSet Property > could be as follows: > charSet=ISO-8859-1 > With this setting, the characers in the database are correctly interpreted. > > Now, with the new 8.4 postgres JDBC driver, this charSet setting is not > supported anymore. > How can I set the character encoding to ISO-8859-1 in the 8.4 Postgres > Driver? > > Thank you very much. > > Regards > Dieter > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/SQL-ASCII-charset-conversion-tp473 > 3958p4733958.html Sent from the PostgreSQL - jdbc mailing list archive at > Nabble.com.