Re: ANSI to Unicode(MSSQL) convertions
From: Nikolai Lukin (nvlukin_at_gran-service.ru)
Date: 01/27/05
- Next message: Aras Kucinskas: "Re: ANSI to Unicode(MSSQL) convertions"
- Previous message: Steve Kass: "Re: Help in solving queries......."
- In reply to: Aras Kucinskas: "ANSI to Unicode(MSSQL) convertions"
- Next in thread: Aras Kucinskas: "Re: ANSI to Unicode(MSSQL) convertions"
- Reply: Aras Kucinskas: "Re: ANSI to Unicode(MSSQL) convertions"
- Messages sorted by: [ date ] [ thread ]
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
strings.
Nick
"Aras Kucinskas" <aras@skuba.lt> wrote in message
news:Ot0I694AFHA.3708@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> 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).
Now
> result is like "ÊÎËÜÖÀ ÊÎÌÏÐÅÑÑÎÐÀ 100ìì ".The ODBC driver does not
> performs the conversion from ANSI to Unicode.
>
> Help.
>
>
- Next message: Aras Kucinskas: "Re: ANSI to Unicode(MSSQL) convertions"
- Previous message: Steve Kass: "Re: Help in solving queries......."
- In reply to: Aras Kucinskas: "ANSI to Unicode(MSSQL) convertions"
- Next in thread: Aras Kucinskas: "Re: ANSI to Unicode(MSSQL) convertions"
- Reply: Aras Kucinskas: "Re: ANSI to Unicode(MSSQL) convertions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
