Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need help on uploading multibyte text files into BLOB and CLOB

franklin.jrApr 25 2019 — edited Apr 25 2019

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.

Regards,

Franklin

Comments
Post Details
Added on Apr 25 2019
1 comment
233 views