in reply to Re^2: SQLite returns funny characters
in thread SQLite returns funny characters

What version of DBD::SQLite is installed?

map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]

Replies are listed 'Best First'.
Re^4: SQLite returns funny characters
by jmClifford (Beadle) on Jul 11, 2024 at 15:19 UTC

    Hi. I just upgrade to version DBD::SQLite 1.74. I suspect it was not installed. However, the previous problem went away. The new problem is;

    $insert->execute(10, '°C'); $insert->execute(80, '°F'); with error messages for both lines UTF-8 "\xB0" does not map to Unicode

    The other (following) response with this thread by roho I suspect may be the answer here. I am unsure of how to implement his/her recommendation.

    Regards JC.....

      Did you save the source code using the UTF-8 encoding?

      map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]