in reply to Re^2: Handling variety of languages/Unicode characters with Spreadsheet::ParseExcel
in thread Handling variety of languages/Unicode characters with Spreadsheet::ParseExcel

Then, are you sure that your .SQL file is UTF-8, and that the text editor you're using to view it understands UTF-8? Most likely you'll want to tell Perl to encode output to UTF-8:

open my $sql_file, '>:encoding(UTF-8)', $sql_name
    or die "Couldn't create '$sql_name': $!";

[download]
  • Comment on Re^3: Handling variety of languages/Unicode characters with Spreadsheet::ParseExcel
  • Download Code

Replies are listed 'Best First'.
Re^4: Handling variety of languages/Unicode characters with Spreadsheet::ParseExcel
by richb (Scribe) on Apr 09, 2010 at 11:41 UTC

    Thanks for your response! Yes to both Qs. The script prints the SQL to STDOUT and I redirect output to a file. The script sets the output encoding to UTF-8 with

    binmode STDOUT, ':utf8';

[reply]

In Section Seekers of Perl Wisdom