Re: ANSI to Unicode(MSSQL) convertions
From: Nikolai Lukin (nvlukin_at_gran-service.ru)
Date: Thu, 27 Jan 2005 07:16:30 +0300
MS SQL usually stores data in CP-1251 for ru_RU locale by default. Your
example here reads as "compressor ring 100 milimeters" in CP-1251 in fact.
Nevertheless, Activex script mechanism doesn't allow codepage translations,
as I was explained here some time ago. You probably need to add some VB /
VB.NET code to your DTS package. Of course, if you do need to translate your
"Aras Kucinskas" <email@example.com> wrote in message
> How to convert and transfer ANSI string data from FoxPro table to MS SQL
> Unicode table. Data in FoxPro are in 1251 codepage (Russian Windows).
> result is like "ÊÎËÜÖÀ ÊÎÌÏÐÅÑÑÎÐÀ 100ìì ".The ODBC driver does not
> performs the conversion from ANSI to Unicode.