Jul 8, 2015, 5:55 PM
Post #1 of 2
Encoding issue on Perl
I have a quick Q on Perl encoding, I am trying to load data from Excel to DB and using this conversion:
my $converter = Text::Iconv -> new ("utf-8", "windows-1252");
my $excel = Spreadsheet::XLSX -> new ($cap_guid_file, $converter);
Excel Data "UNIVERSITE DE MONTRÉAL L" is getting converted to "UNIVERSITE DE MONTR�AL L" in DB.
I tried doing utf-8 to utf-8 OR utf-8 to latin, but no luck. Appreciate any help.