Re: Unicode insert into mssql from perl DBD

Use DBD::ODBC 1.14 or newer, enable Unicode support (is enabled on Win32, is disabled on Non-Win32) and make sure that unicode data passed in via placeholders is properly tagged as utf8 in Perl.

Alexander Foken

Comment on Re: Unicode insert into mssql from perl DBD

Replies are listed 'Best First'.
Re^2: Unicode insert into mssql from perl DBD by rhesa (Vicar) on Jan 02, 2008 at 22:33 UTC
Thanks, I'm going to give that a try! ADO works okay, but has some annoying drawbacks (e.g. I couldn't use a column named "language").	[reply]
Re^2: Unicode insert into mssql from perl DBD by Anonymous Monk on Jan 03, 2008 at 09:53 UTC
I`ve tried both approaches. DBD-ODBC 1.14 is not in the activeState repository unfortunately and I have not succeeded in building it my self. Using Ado has poved more promissing, but I faced entirely new issues. (e.g. consecutive executes of a prepared insert will chop off values in varchar columns to the length of the first insert.... interesting). Life's a workaround.... Thanks for all the advice	[reply]