I had to use the nls_language variable to inform the database that I wanted extended characters. I used french_france, but there must be a way to use latin1. You could try use utf8 on your side, but that didn't seem to make any difference.
Ford Motor Company
Sent: Tuesday, September 10, 2002 4:34 PM
To: Perl "Users Help (E-mail)
Subject: DBD:ODBC - Retrieving Unicode values on W2K + MSSQL 2000
Using ActiveState Perl 5.6.1 build 633
The following happens when using either ActiveState's DBI & DBD:ODBC
ppds or the latest ones posted by Jeff Urlwin.
When retrieving ntext, nvarchar et al. values from a MS SQL 2000 server
using DBD::ODBC, extended characters show up as ?????
I'm also unable to get "correct" values through DBD::ADO, Win32::OLE and
Win32::ODBC, even when disabling AutoTranslate in the DSN properties.
The only workaround I have found is by using DBD:JDBC (with a bad hack
for SQL_BIGINT) and MS's JDBC driver.
I've also tried to find hints as to where or what to look for in various
lists and archives, but to no avail.
Is it possible to retrieve / insert Unicode values using DBD::ODBC and
MS SQL 2000 ? If so, what am I missing here ?