| 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: | Whole Thread | Raw Message | 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?
?
| 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 |