File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes ORA-00911: invalid character error if sql statement read from a utf-8 encoded file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "ORA-00911: invalid character error if sql statement read from a utf-8 encoded file" Watch "ORA-00911: invalid character error if sql statement read from a utf-8 encoded file" New topic
Author

ORA-00911: invalid character error if sql statement read from a utf-8 encoded file

vamsi kris
Greenhorn

Joined: Feb 04, 2009
Posts: 28

Hi All,

it is really strange, if i read a statement from a UTF-8 encoded file but if i encode the same file in ANSI and fetch the data from this file and execute the same statement its working. can some one please help me in this. i need the file to be in utf-8 because in some cases there may be some special german characters.


SCJP 1.5 97%
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14687
    
  16

What did you use to read the file ?


[My Blog]
All roads lead to JavaRanch
 
wood burning stoves
 
subject: ORA-00911: invalid character error if sql statement read from a utf-8 encoded file
 
Similar Threads
Encoding Question
How to read Franch from ResourceBundle
UTF-16 and loadXML
inputstream
Unicode Char Problem