Problem with retrieve ResultSet.getBytes("columnName");

You only need encoding when you want to convert it to or from a String. And I really shouldn't use getString(), you are never sure of the type encoding applied (which is generally the one from the JVM). Rather use the constructor of String which accepts the charset.

byte[] bytes = resultSet.getBytes("columnname");

String encodedString = new String(bytes, charset);

The database-side encoding capabilities only applies to String fields (Varchar, Text, etc) by the way. You don't need to care them for the byte arrays.

BalusCa at 2007-7-12 10:13:47 >

> What should I do to accomplish my task?

>

First of all prove that the bytes stored in the database are the Urdu bytes you expect. There is not point in worrying about how to get them from the database until you are certain that you have store what you think you have stored.

Again, why are you using bytes and not characters?

sabre150a at 2007-7-12 10:13:47 >

> Again, why are you using bytes and not characters?

I have tried everything that I could do.

I have also tested with characters as well.

For storing character I did the following steps

STEP-1

Change the column datatye to NVARCHAR

STEP-2

To reterieve I use the following code

ResultSet.getString("column name");

When I call getString("columnName") on the DB column which is NVARCHAR, it returns null even though a value exists there.

Is there any driver problem or what? But I dont think so that driver can be the problem...

What to do next...... ?

Where am I going wrong...?

Java_persona at 2007-7-12 10:13:47 >