On 15/09/2010 21:15, Michael Ludwig wrote:
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!
I didn't entirely get it but enough to fix it.
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
DBD::ODBC 1.24_5 uploaded to CPAN now but your mirror might take longer
for you to see.
I would not get too excited as I did not try the native client yet and
don't have it at home so it will have to wait until tomorrow. It might
be less bother for you to wait until I've tried native client (tomorrow
hopefully).
Martin
