CSV from Excel with special Characters such as éñÏôèéóéóñîêÄü_Ç (aka Germanic umlaut) to Oracle Table via (APEX)

[Paul Ungaretti]

The LOB2Table function with 'WE8ISO8859P15' specified as the character_set handles this quite well.

function separatedcolumns(p_blob blob,
p_row_separator varchar2,
p_column_separator varchar2,
p_character_set varchar2 := null, / Here /
p_delimiter varchar2 := null,
p_truncate_columns number := 0)
return lob_rows pipelined;

I've also had success with Data Worshop setting the File Character set to Western European ISO-8859-1
h t t p s : // en.wikipedia.org/wiki/ISO/IEC_8859-15

[Michael]

Hi Paul,

thanks for this good news - and for the review!

Knowing the correct charset of the file (that is: of the BLOB) is of course very important to get LOB2Table to work fine.

As far as I know this can be a quite nasty issue when you create a CSV with Excel because Excel seems to use the charset of the system - this may be some western charset in Europe/US, some other charset in Russia or something very different in Asia.

This may make it necessary to allow the user to specifiy the charset of his file in the upload process...

Best,
Michael