Hello Martin, Martin Evans schrieb:
What do you mean by that? Select stops working it you stipulate your perl script is utf-8?
Yes: When adding "use encoding 'utf8'" the result reads like this:
1 G?nz v?le ?ml?ute und ?eugs
You need to use utf8 to have utf-8 encoded data in your Perl script.
You mean "use utf8"? Tried this, no success.
Your setup looks ok except I am not familiar with a "unicode built" FreeTDS (what does that mean and what does it change in FreeTDS).
Sorry, I mixed things up. There is no Unicode option for FreeTDS.
I have a default build of freeTDS here and it passes the unicode tests in DBD::OBDC's t dir. Does your setup pass the DBD::ODBC tests?
No, it does not:t/40UnicodeRoundTrip.t .. 1/63 DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Invalid data type (SQL-HY004) at t/40UnicodeRoundTrip.t line 116.
# Failed test 'no warnings'
# at t/40UnicodeRoundTrip.t line 53.
# There were 1 warning(s)
# Previous test 9 'bind WVARCHAR'
# DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Invalid data type (SQL-HY004) at t/40UnicodeRoundTrip.t line
116.
# at t/40UnicodeRoundTrip.t line 116
#
# Looks like you planned 63 tests but ran 10.
# Looks like you failed 1 test of 10 run.
# Looks like your test exited with 255 just after 10.
t/40UnicodeRoundTrip.t .. Dubious, test returned 255 (wstat 65280,
0xff00)
Failed 54/63 subtests
t/41Unicode.t ........... 1/56 DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Invalid data type (SQL-HY004) at
t/41Unicode.t line 118.
# Failed test 'no warnings'
# at t/41Unicode.t line 49.
# There were 1 warning(s)
# Previous test 8 'Bind parameter SQL_WVARCHAR'
# DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL
Server]Invalid data type (SQL-HY004) at t/41Unicode.t line 118.
# at t/41Unicode.t line 118
#
# Looks like you planned 56 tests but ran 9.
# Looks like you failed 1 test of 9 run.
# Looks like your test exited with 255 just after 9.
t/41Unicode.t ........... Dubious, test returned 255 (wstat 65280,
0xff00)
Failed 48/56 subtests
Anyway, some other test fail as well but besides the Unicode issue everything
is working fine.
Regards,
Stephan
smime.p7s
Description: S/MIME Cryptographic Signature
