1 Reply Latest reply on Apr 26, 2019 3:28 AM by Gaz in Oz

    Need help on uploading multibyte text files into BLOB and CLOB


      I have a database routine which reads files from local file system and imports them into a BLOB table field. Text file contents have to be processed and they can come in different formats (ANSI, UTF-8) and encodings (either english or multibyte from other countries). Since these international text contents are being truncated due to being multibyte, I need advice on how this can be properly handled.


      I usually have no issues with brazilian portuguese text files, but dealing with files in spanish language is being harder.


      At this moment I use Oracle 11 XE. Thanks in advance.