I have Russian source data (Unicode) which I need to get
into a varchar column with SQL_Latin1_General_CP1250_CI_AS
collation. I know the characters will apper screwed up
but this doesn't matter at this stage.
Further down the line, this data will be exported into an
ANSI text file (along with English and French
translations, etc) for loading onto a Russian customer's
PC. This will be input into an existing system that does
not accept Unicode encoded files. Hence, the Russian
characters will then show correctly.
I have tried a number of approaches but so far have just
ended up with a series of ? characters (dec 63). I can
bulk insert the data into a varchar 1251 column and check
that the ANSI codes are correct but I cannot progress to
getting the same ansi codes to appear in the 1250 column -
just the question marks and the odd one or two that do
translate.
into a varchar column with SQL_Latin1_General_CP1250_CI_AS
collation. I know the characters will apper screwed up
but this doesn't matter at this stage.
Further down the line, this data will be exported into an
ANSI text file (along with English and French
translations, etc) for loading onto a Russian customer's
PC. This will be input into an existing system that does
not accept Unicode encoded files. Hence, the Russian
characters will then show correctly.
I have tried a number of approaches but so far have just
ended up with a series of ? characters (dec 63). I can
bulk insert the data into a varchar 1251 column and check
that the ANSI codes are correct but I cannot progress to
getting the same ansi codes to appear in the 1250 column -
just the question marks and the odd one or two that do
translate.