Re: how to read from utf8 text file?

If the file is in UTF-8 indeed, open your file like this:

open my $handle, '<:encoding(UTF-8)', $name
    or die "Can't open '$name' for reading: $!";
[download]

Then you also have to decide for an encoding when you enter it into your database, or print it to your console.

You have to know your DBs encoding for that, and I know too little of Microsoft's various programs to help you with that.

I think MS uses UTF-16le for many things, it might be worth a try.

Comment on Re: how to read from utf8 text file? Download Code

Replies are listed 'Best First'.
Re^2: how to read from utf8 text file? by Juerd (Abbot) on Jul 01, 2008 at 12:54 UTC
Hi. Please note that perluniintro and perlunicode are experienced as tough and opaque for people either new to Perl or new to character encodings. That's why I've written perlunitut and perlunifaq a while ago. These may be better suited for someone asking a basic question. They're distributed with Perl nowadays. Juerd # { site => 'juerd.nl', do_not_use => 'spamtrap', perl6_server => 'feather' }	[reply]
Re^2: how to read from utf8 text file? by MelaOS (Beadle) on Jul 01, 2008 at 12:55 UTC
hi man, thanks for the prompt reply, i've tried the opening method, but when i write back out to a text file just for testing right. all the strings looks like gibberish. is there any good way to verify how perl is reading my utf8 strings? i've tried inserting utf8 directly into ms access. so the only thing i'm worried about here is how the text get handled in perl before it get passed over to access. thanks	[reply]
Re^2: how to read from utf8 text file? by umesh_epub (Novice) on Aug 13, 2012 at 12:00 UTC
Thanks, Its' worked for me....	[reply]