Convert Cyrillic data

vijayg · Post by **vijayg** » Mon Mar 24, 2008 1:28 pm

We are working with the Russian data that is converted to Cyrillic charecter, how to convert it back(Russian)? I am not sure how the data was converted to Cyrillic. If we can do it in datastage that is well and good, can this be done in Unix?

Thanks for the help.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 24, 2008 3:27 pm

You need to find out, obviously, how it was converted to Cyrillic characters in the first place (nothing unexpected should happen in ETL). The short answer is that there are character maps between the outside world and DataStage, that convert from and to the external character set.

There is no mechanism whatsoever in DataStage for converting from English to Russian, unless you implement it yourself.

Sudhindra_ps · Post by **Sudhindra_ps** » Mon Mar 24, 2008 3:46 pm

hi,

You could do this in Unix by using iconv function. The syntax for which is as below.
iconv -f <FromSourceCodePage> -t <ToTargetCodePage> <FileNameTobeConverted.txt> > <DestinationFileName>

Thanks & regards
Sudhindra P S

ray.wurlod · Post by **ray.wurlod** » Mon Mar 24, 2008 4:58 pm

When I did a man iconv on my Linux server it professed ignorance. Does this command come with UNIX or is it something you built yourself?

Sudhindra_ps · Post by **Sudhindra_ps** » Mon Mar 24, 2008 5:34 pm

hi Ray,

iconv command comes with UNIX. Please see documentation for the same in the below mentioned link.
http://www.gnu.org/software/libiconv/do ... onv.1.html

Thanks & regards
Sudhindra P S

ray.wurlod · Post by **ray.wurlod** » Mon Mar 24, 2008 7:14 pm

But not in the man pages.

Thank you for the link.

chulett · Post by **chulett** » Mon Mar 24, 2008 8:11 pm

Interesting. Iconv and man pages both here under HP-UX.

ArndW · Post by **ArndW** » Tue Mar 25, 2008 2:12 am

man pages for the iconv function are present on AIX as well.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 25, 2008 2:35 am

Turns out some man pages had been removed, to "save disk space".

chulett · Post by **chulett** » Tue Mar 25, 2008 6:54 am

Brilliant! Who needs them gi-huge-ic man pages, anywho.

vijayg · Post by **vijayg** » Tue Mar 25, 2008 8:05 am

Thanks Guys. Sundhindra's Unix command works great for what we are doing. Appriciate it.