Re: Encoding Problem

From: Marc Herbert <Marc(dot)Herbert(at)continuent(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Encoding Problem
Date: 2006-08-31 08:44:50
Message-ID: khjd5ahz43h.fsf@meije.emic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

"meil parachorras" <meilparachorras(at)hotmail(dot)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?

?

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mario Splivalo 2006-08-31 09:22:39 Re: Catching postgres exceptions - functions returning
Previous Message Dave Cramer 2006-08-31 01:00:02 Re: jdbc3, pg 8.1.4 , and stored procedures