ResultSet.getBytes()

[Mathias Nilsson]

Hi!
I have a big problem. I'm trying to write data to an access 2000 db
using JDBC. So far I have succeded with inserting data.
ex

byte[]  data  = �My test string�.getBytes("UTF-8");
preparedStatement.setBinaryStream(1, new ByteArrayInputStream(data), data.length);

When I'm about to print the data I use

byte b[] = result.getBytes( "EventText" ); // ResultSet
String s = new String( b , "UTF-8" );

It only prints '???A' and so on. How can I print the real data inserted via
an textarea? I don�t wan't to use getString() and setString() because length of the data is to long. I've tried it an it generates an odbc error by truncating the string.
I have tried using ( "ISO-8859-1" ) to but it still doesn't work.
Anybody know the solution to this problem?
// Mathias

[Mathias Nilsson]

Hi all.
I solved it. If you use

setAsciiStream it will work fine

// Mathias