Re: Changes in binding columns in DBD::ODBC

"Martin J. Evans" <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase.devel
Organization Easysoft Limited
Message-ID <[email protected]>
On 21/05/12 13:43, Tim wrote:
> On Mon, May 21, 2012 at 02:50:02AM -0000, Greg Sabino Mullane wrote:
>>
>>> 1. Columns described as SQL_INTEGER will be bound as SQL_C_LONG and
>>> hence retrieved as a C long and the bound scalar will be set using
>>> sv_setiv
>> ..
>>> 2. You cannot override the bound column type.
>>
>> +1, sounds sensible.
>
> It does. Though I suspect people using code that depends on the internal
> numeric vs string distinction will encounter problems.
>
> One example that springs to mind is JSON serialization
> http://search.cpan.org/~mlehmann/JSON-XS/XS.pm#PERL_-%3E_JSON
>
> Tim.

It actually makes JSON::XS work whereas it didn't before unless you used TYPE => SQL_INTEGER and DiscardString => 1. Unless of course, you mean some one using JSON::XS would have got "NNN" and now will get NNN (I thought the latter was preferably).

JSON::XS was my original usage case for DiscardString.

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.