Re: Encoding Problem - Mailing list pgsql-jdbc

From Marc Herbert
Subject Re: Encoding Problem
Date
Msg-id khjd5ahz43h.fsf@meije.emic.fr
Whole thread Raw
In response to Encoding Problem  ("meil parachorras" <meilparachorras@hotmail.com>)
List pgsql-jdbc
"meil parachorras" <meilparachorras@hotmail.com> writes:

> Example:
> Class.forName("org.postgresql.Driver");
> String url = "jdbc:postgresql://localhost:5432/GE";
> Connection con = DriverManager.getConnection(url,"user","pass");
> Statement st = con.createStatement();
> sql = "INSERT INTO Auffinden VALUES ('1','München');";
> ResultSet res = st.executeQuery(sql);
> con.close();
>
> And I receive this error:
> org.postgresql.util.PSQLException: ERROR: character 0xc383 of encoding
> "UTF8" has no equivalent in "ISO_8859_5".

You configured your database with a cyrillic alphabet. The error
message just means that ü (u umlaut) does not exist in this cyrillic
alphabet, you cannot write this character in cyrillic. This is NOT an
encoding issue, it's a charset issue: this character does not exist in
this charset, so there is no way you can insert it, whatever the
encoding(s).

<http://czyborra.com/charsets/iso8859.html#ISO-8859-5>

You'll easily find more detailed explanations if you search the web.


> How can I data with encoding ISO_8859_5 with JDBC senden?

?

pgsql-jdbc by date:

Previous
From: "meil parachorras"
Date:
Subject: Encoding Problem
Next
From: Mario Splivalo
Date:
Subject: Re: Catching postgres exceptions - functions returning