Hi,
I have a problem where our DB is displaying weird characters.
the data entered is....
The db is showing...
I've tried to use the unicode module like so...
but that's made things worse...
So what am I doing wrong and how do I deal with these dodgy chars?
Thanks,
1DMF
"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Google Rank Extractor -> Perl beta with FusionCharts
I have a problem where our DB is displaying weird characters.
the data entered is....
App 1 – sum assured to include existing mortgage (£110k) plus new mortgage (£150k) – existing policy has been retained (also £110k) and new policy applied for is £260k therefore client will have total life cover of £370k?
The db is showing...
App 1 – sum assured to include existing mortgage (£110k) plus new mortgage (£150k) – existing policy has been retained (also £110k) and new policy applied for is £260k therefore client will have total life cover of £370k?
I've tried to use the unicode module like so...
Code:
# use encoding for unicode characters
use Unicode::String;
Unicode::String->stringify_as( 'utf8' );
# notes
my $nt = $cgi->param('NT');
$nt =~ s/\'/\'\'/g;
$nt = Unicode::String::latin1( $nt );
but that's made things worse...
App 1 – sum assured to include existing mortgage (£110k) plus new mortgage (£150k) – existing policy has been retained (also £110k) and new policy applied for is £260k therefore client will have total life cover of £370k?
So what am I doing wrong and how do I deal with these dodgy chars?
Thanks,
1DMF
"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Google Rank Extractor -> Perl beta with FusionCharts