Re: Need Help with Unicode on ActivePerl 5.8.6, MS SQL 2000
- From: Tim.Bunce@xxxxxxxxx (Tim Bunce)
- Date: Fri, 29 Jul 2005 16:43:27 +0100
On Thu, Jul 28, 2005 at 04:14:16PM +0200, Alexander Foken wrote:
> Hello,
>
> A large Perl application (10^4 .. 10^5 lines of code) has to work with
> data on an MS SQL Server 2000 containing Unicode data in NVARCHAR
> columns. Perl 5.8.6 (ActivePerl) runs on the same or another Windows
> 2000 Server (usually english or german). The Unicode data may contain
> characters from all over the world, e.g. russian, chinese, arabic or
> hebrew, among the usual latin characters. A separate application also
> accesses the Database, performs some reporting and expects the data to
> be valid Unicode.
>
> DBD::ODBC returns all latin characters, german umlauts and french
> accents, but replaces all non-latin characters with question marks
> ("?", ASCII 63). Also, all data returned from DBD::ODBC has the UTF8
> flag off.
> I spent three days searching Google, DBI docs and FAQ, and DBI and
> DBD::ODBC sources for any hints, but without success.
>
> Any ideas, hints, tips?
I'd suggest you work with the maintainers of DBD::ODBC to fix it and
help save the world.
Tim.
.
- References:
- Need Help with Unicode on ActivePerl 5.8.6, MS SQL 2000
- From: Alexander Foken
- Need Help with Unicode on ActivePerl 5.8.6, MS SQL 2000
- Prev by Date: Re: Inserting UTF-8 string over 2000 chars to Oracle 10g - error ORA-01461
- Next by Date: Need to retrieve columns names from result using DBI.
- Previous by thread: Need Help with Unicode on ActivePerl 5.8.6, MS SQL 2000
- Next by thread: Retrieving column names using DBI and SQL Server
- Index(es):
Relevant Pages
|
