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.