You have to use

prop.setProperty("lc_ctype", "ISO8859_1");

to set the charset.

Best regards,

Juan Pedro Lopez

> Its my first post and i searched the messages and didn't found an
> answer...
>
> Im trying to use a ISO8859_1 charset and always receiving the
> "transliteration" message.
>
> My varchar fields are created w/ ISO8859_1 and works ok in IBAccess,
> but not in java...
>
> I tryed this:
>
>
> Properties prop = new Properties();
> prop.setProperty("user", user);
> prop.setProperty("password", pass);
> prop.setProperty("CHARSET", "ISO8859_1"); // "charSet", "charset"
> connDB = DriverManager.getConnection(sc.toString(), prop);
> connDB.setAutoCommit(true);
> Statement st = connDB.createStatement();
> st.executeUpdate("INSERT INTO TTT (NNN) VALUES ('áéíõç')");
>
> I used the column as OCTETS and it worked (no err msgs) but what is
> writen is diferent of what is read...
>
> Anyone can help?
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> click here
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
Juan Pedro López Sáez
ALTIRIA TIC, S.L.L.
www.altiria.com