You don't show us what Perl code you used to insert the degree sign into the database. Most likely this brings us back to your original thread, in which some questions to your code are still open.
My personal recommendation is to avoid Unicode / non-ascii in your source code and use the \N{} notation:
use charnames ':full';
my $fahrenheit = "\N{DEGREE SIGN}F";
# ... use $fahrenheit where you otherwise would type °F
The difference between SQLite Expert, Perl and the console output still comes out to that the strings you display with  are undecoded UTF-8 strings. This can have multiple causes, as discussed in SQLite returns funny characters.
If you have mixed string in your table, you will have to run an UPDATE SQL command to fix your database. But before you do that, make sure that your code is consistent.
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
|
|
