Re^2: SQLite returns funny characters

Thanks to Choroba for the contained sample. My issue now is:

Can't continue after import errors
"dbd_sqlite_string_mode" is not defined in %DBD::SQLite::Constants::EX
+PORT_TAGS
[download]

I can assess SQLite DBs with other Perl files. Is this a case of updating to the latest ? I don't think I have ever "CSPAN"ed a DBD module onto my Win10 system.

Regards JC....

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

Replies are listed 'Best First'.
Re^3: SQLite returns funny characters by choroba (Cardinal) on Jul 10, 2024 at 08:46 UTC
What version of DBD::SQLite is installed? `map{substr$_->[0],$_->[1]\|\|0,1}[\\|\|{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^ARGV,3]`	[reply] [d/l]
Re^4: SQLite returns funny characters by jmClifford (Acolyte) 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` [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.....	[reply] [d/l]
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]


No such thing as a small change
	PerlMonks