Changing charset from UTF-16 to ISO 8859-1

[John Sisco]

Hello,

I'm having problems with PostgreSQL that has some major difficulties converting scandinavian UTF-16 characters (ä - a with dots, ö - o with dots) to ISO 8859-1.

----

java.sql.SQLException: ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1

----

^- I think the error above is wrong because java uses UTF-16, right ?

Well anyway, I was thinking that I could go around this problem by making the conversion on the java-side, but have some difficulties understanding the java.nio-package.

So the task is to have the sql-string to include the foobar variable as ISO-8859-1, and the code belove manages not to give the SQLException above, but am I just making a UTF-16 -> ISO 8859-1 -> UTF-16 encoding/decoding there ?

 
Charset charset = Charset.forName("ISO-8859-1");
CharsetEncoder encoder = charset.newEncoder();
CharsetDecoder decoder = charset.newDecoder();
 
ByteBuffer bbuf = encoder.encode(CharBuffer.wrap(st.nextToken()));
CharBuffer cbuf = decoder.decode(bbuf);
foobar = cbuf.toString();
 
sql = "INSERT INTO foo (bar) VALUES ('"+foobar+"');";
stmt.executeUpdate(sql);