ok. i had forgotten one thing you mentioned earlier, which is that
you're using thick (oci8) driver. with the thin driver i couldn't
reproduce your problem but the thick driver does exhibit the "?"
behavior with the clob. it may have something to do with sqlnet nls
settings, i guess. can you use the thin driver?
"Ilia" <nospam_at_deathtospam.com> wrote in message news:<rsEQa.113224$8B.96592_at_twister.nyroc.rr.com>...
> int num = stmt.executeUpdate("delete from test");
>
> // t.in contains 256 characters 0x00-0xff, -Dfile.encoding=ISO-8859-1
> ensures that we use ISO-8859-1
> String chars = Misc.getFileAsString("c:/tmp/t.in");
>
> // table test contains two columns, first is varchar2 (256), second is a
> CLOB
> pstmt = dbconn.prepareStatement("insert into test values (?,?)");
> pstmt.setString(1, chars.substring(128, 1));
> pstmt.setString(2, chars.substring(128, 1));
> pstmt.executeUpdate();
> ResultSet rset = stmt.executeQuery("select * from test");
>
> rset.next();
> String newchars = rset.getString(1);
> Clob newcharsclob = rset.getClob(2);
> String newchars2 = newcharsclob.getSubString(1,
> (int)newcharsclob.length());
>
> close(dbconn);
>
> System.out.println(newchars);
> System.out.println(newchars2);
>
> The first displays Euro, the second displays ?
>
> When I look at the data with Toad, database contains Euro in both fields, so
> I am guessing it's JDBC. I assume Toad uses some other database interface.
>
>
> "bung ho" <bung_ho_at_hotmail.com> wrote in message
> news:567a1b1.0307141043.4186097a_at_posting.google.com...
> > woops. i don't know why it doesn't work for you then, it prints out
> > the euro for me fine (and i have almost the exact same setup as you).
> > maybe you should post your code (the CLOB insert as well as the
> > retrieval and print statements)
> >
> > the fact that it's only 0x80-0x9f still makes me think it has
> > something to do with Cp1252 vs. ISO-8859-1.
> >
> >
> >
> > "Ilia" <nospam_at_deathtospam.com> wrote in message
> news:<zsDPa.101359$8B.52664_at_twister.nyroc.rr.com>...
> > > Thank you for your interest, here is more info:
> > >
> > > I run java program on Windows XP professional, JVM 1.3.1 with
> > > a -Dfile.encoding=ISO-8859-1 JVM parameter. Oracle server is running
> under
> > > Linux 7.3.
> > >
> > > With this parameter, code
> > >
> > > char c = 0x80
> > > System.out.println(c);
> > >
> > > prints out a Euro symbol.
> > >
> > > You are right and the range is 0x80-0x9f.
> > >
Received on Tue Jul 15 2003 - 11:42:08 CDT
