Re: DBD::OCBC support for XML datatype in SQL Server 2005

[email protected] (Michael Ludwig)
Newsgroups perl.dbi.users
Message-ID <20100915201558.GB5428@wladimir>
Martin J. Evans schrieb am 15.09.2010 um 17:55 (+0100):
> Firstly, DBI DOES define SQL_WCHAR so if you pull in :sql_types you
> can used SQL_WCHAR instead of using -8.

Yes.

> Also, the mystery over the length() call producing the wrong result
> was a missing call to SvSETMAGIC (big thanks to Perl Monks and in
> particular ikegami). You can find the node at
> http://www.perlmonks.org/?node_id=860211, but some of the discussion
> took place in the chatterbox. I will fix this for the next release.

Thanks. Internals is something I don't grok yet. But thanks for your
investigative work!

> So, Michael, you really need to make a few changes to your script and
> then you need a new DBD::ODBC which I can send you. Let me know.

As stated:

* INSERT will need guidance or upgrade (see my other reply)
* SELECT will need a patch from you

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