Read Unicode chars and insert into Oracle DB

[Mahesh Pinnamaneni]

Guys,

I am having a file in which some of the text was in Unicode format.
I want to read this file in Java and insert into oracle database.
The following is the code for reading the unicode string from the file.

 
public String loadString(String filename) {
    StringBuffer text = new StringBuffer();
    FileInputStream instream;
    BufferedInputStream buffer;
    int readint;
    try {
      instream = new FileInputStream(filename);
      buffer = new BufferedInputStream(instream);
      Reader reader = new InputStreamReader(buffer, "Unicode");
       while ((readint = reader.read()) != -1) {
        text.append( (char) readint);
      }
      buffer.close();
      instream.close();
    } catch (Exception e) {e.printStackTrace(); }
   return text.toString();
  }

Java is reading the correct unicode (i can see this while debuggin the code). Is there any way to insert the Unicode chars to DB.

I am viewing the chars in the html page with Encoding set to 'Central European - Windows).

Please help..

Thanks & Regards,
Mahesh P

[Yuriy Zilbergleyt]

Have you tried simply storing the string as VARCHAR2? If that doesn't work, you can always serialize them to BLOB.

Yuriy

[Mahesh Pinnamaneni]

Thanks for ur reply...

The database column used is NVarchar to store Unicode format..

Regards,
Mahesh P

[Paul Sturrock]

Originally posted by Mahesh Pinnamaneni:
Thanks for ur reply...

The database column used is NVarchar to store Unicode format..

Regards,
Mahesh P

...unless that database itself is configured to support Unicode, in which case you can store unicode data in chars, varchars, clobs and longs.