I created a Greek text and saved in in UTF8 format (using textpad)
Then I uploaded it in the application.
When I searched greek words, it found them immediately all of them without any issue!!!!!
When I saved the same text as ANSI and uploaded it found nothing!!!
So the problem is the encoding. I realize that 11g XE is coming only on UTF8. Is there a method that I can use to upload documents that will allow me to convert everything on the fly to utf8 before indexing?
Do you know if I can apply something like this during the upload of a document through APEX? Consider the original docman sample app. How it will treat a pdf or docx document (or any other document) with embedded text?