Try using "lc_ctype" as the property key instead of "CHARSET".

This should work.
Michael

> -----Original Message-----
> From: martinifloripa [mailto:martini@...]
> Sent: Thursday, September 11, 2003 3:15 PM
> To: Firebird-Java@yahoogroups.com
> Subject: [Firebird-Java] Where to configure Charsets?
>
>
> 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
> ---------------------~-->
> Upgrade to 128-Bit SSL Security!
> http://us.click.yahoo.com/p7cEmB/s7qGAA/yigFAA/saFolB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>