Thanks again almut, as your post is very enlightening and helping me to understand what is going on.

To be honest what originally drove this was my requirement to get IVs created (only and not a pv) when you have an integer as JSON::XS (oh how I'm going to regret adding this comment) does something different when an sv has an IV but not a pv. See Support binding of integers so they are returned as IVs and DBD::Oracle, Support binding of integers so they are returnedas IVs. I was not bothered about doubles, numerics and bigints myself but was happy to help introduce a more general solution to DBI. As it turns out, it has been a lot more work than I first thought but still worth it for us since it avoids us having to loop through a database result-set and add 0 to all the values we know are small integers.

In reply to Re^8: Why does sv_2nv on non-number look like an NV by mje
in thread Why does sv_2nv on non-number look like an NV by mje

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • 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, details, 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, summary, 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:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.