Re^4: SQLite returns funny characters

by jmClifford (Acolyte)

on Jul 11, 2024 at 15:19 UTC ( [id://11160551]=note: print w/replies, xml )

Need Help??

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
[download]

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.....

Comment on Re^4: SQLite returns funny characters Download Code

Replies are listed 'Best First'.
Re^5: SQLite returns funny characters by choroba (Cardinal) on Jul 11, 2024 at 21:31 UTC
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]`	[reply] [d/l]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://11160551]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others having an uproarious good time at the Monastery: (6)

As of 2024-09-18 15:26 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

The PerlMonks site front end has:

Results (25 votes). Check out past polls.

Notices^?

	• erzuuli	‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.