CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Intermediate:
Encoding issue on Perl

 



Shreekanta
New User

Jul 8, 2015, 5:55 PM

Post #1 of 2 (2116 views)
Encoding issue on Perl Can't Post

Hi,
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.

Thanks
Shreekant


Laurent_R
Veteran / Moderator

Jul 9, 2015, 10:42 AM

Post #2 of 2 (2088 views)
Re: [Shreekanta] Encoding issue on Perl [In reply to] Can't Post

Hi,

take a look at the "Unicode and Strings" chapter in this web page http://modernperlbooks.com/books/modern_perl/chapter_03.html#toc_VGhlUGVybExhbmd1YWdl (chapter 3 of Modern Perl, by chromatic. I think tt is explained there much better than I could ever do.

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives