Unicode Transformation Format Utf Utf8 Utf16 Projects
Looking for freelance Unicode Transformation Format Utf Utf8 Utf16 jobs and project work? PeoplePerHour has you covered.
Post an offer to educate them
Past "Unicode-transformation-format-utf-utf8-utf16" Projects
PL/SQL Expert for RTF Extraction from BLOB and to be transferred to HTML with ctx_doc
This is something we can easily do in TSQL on SQL Server but for which we don't have the PL/SQL on Oracle RAC expertise. The challenge: - A unicode table contains a BLOB field (not a CLOB) with encoded RTF text - We can get the RTF text by casting it to a varchar2 character but the problem this is that this variable is limited to 2000 characters in unicode - This would be a sample select that perfectly extracts the rtf string from the blob into multiple 2000 character varchar2 variables: select utl_raw.cast_to_varchar2(dbms_lob.substr(gdtxft,2000,1)) as DESCMF01, utl_raw.cast_to_varchar2(dbms_lob.substr(gdtxft,2000,2001)) as DESCMF02 from F00165 where GDTXKY = '128374|MN' - The idea would be to have a stored procedure that can extract the RTF in one go and transform it in HTML using the embedded ctx_doc library and would provide a full string with the HTML data. The RTF formatting is really basic only (2000 standard) so ctx_doc should be able to do this without a problem. So the deliverable should be the code to extract the full RTF data and do the transformation to HTML and return a full string with the html data. Please provide an estimate for this development.