Java Read binary record into String

Question

We are storing uploaded text files in a SQL server data. The field type is image.

The file upload and download correctly, what I want to do now is load the actual text content into a String variable directly from the database record.

Can anyone advise on how to do this please?

Thomas · Accepted Answer · 2011-03-24 10:40:39Z

3

Depends on how you read the data from the db. If you get a byte array, you could use new String(bytes);

Btw, why don't you use the CLOB datatype (or the equivalent for your server) for the field? This should normally cause the Java driver to return the String directly.

answered Mar 24, 2011 at 10:40

Thomas

88.9k13 gold badges126 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Kev Over a year ago

Thanks Thomas; the String(bytes) answer was just the prompt I needed. Problem solved. Cheers.

Joachim Sauer Over a year ago

Note that using new String(byte[]) without a second parameter will use the platform default encoding which can lead to problems when you run it on different computers or with different configurations! Whenever possible, you should specify which encoding the text is in!

Thomas Over a year ago

@Joachim That's true, and id the endocing can vary, it might be stored in the dataset as well.

Collectives™ on Stack Overflow

Java Read binary record into String

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related