perl character encoding
I have a perl script that takes text values from a mysql table and writes it to a text file. The problem is, when I open the text file for viewing I am getting a lot of hex characters like \x92 and \x93 which stands for single and double quotes...I guess.

I am using DBI->quote function to escape the special chars before writing the values to the text file.


I have tried using Encode::Encoder, but with no luck. The character set on both the tables is latin1 

How do I get rid of those hex characters and get the character to show in the text file.

Many Thanks 
perl character encoding
===

I have a perl script that takes text values from a mysql table and writes it to a text file. The problem is, when I open the text file for viewing I am getting a lot of hex characters like \x92 and \x93 which stands for single and double quotes...I guess.

I am using DBI->quote function to escape the special chars before writing the values to the text file.


I have tried using Encode::Encoder, but with no luck. The character set on both the tables is latin1 

How do I get rid of those hex characters and get the character to show in the text file.

Many Thanks 