Re: problem inserting spanish character into mysql

Are you sure the xml file is in utf-8 format? What if it's a plain ASCII text file?

what if you try:

open (my $fh, '<', $filename)

Btw, I don't think, you need 16 bits to represent Spanish characters. Letters like "ó" and "ñ" can be encoded in just 8 bits.

Comment on Re: problem inserting spanish character into mysql

Replies are listed 'Best First'.
Re^2: problem inserting spanish character into mysql by smithyed (Initiate) on Aug 01, 2016 at 06:14 UTC
Well, I moved the code and database over to a Centos 6 machine with Perl 5.10 and Mariadb 10.1 and ..... it just worked. shrugs Thank you to all who looked at this and contributed!	[reply]