Arabic Data
Hi Every1. my client has got a data in Informix Online 5.x with r4gl used for the front end. the character based screen display in Arabic. The data stored in the field are numbers and on column is the name which is in Arabic. This data is exported using the unload utility to an ascii file. the data then is imported to MS-Excel. This Excel file has to sent to the Head Office of the company. But the data imported into Excel does not display the name in Arabic even though the pc has arabic installed in it. I am able to type in the same excel sheet some Arabic characters as well. How do I get this Informix data unloaded to be displaye in Arabic? Help would be greatly appreciated. Regards RAMANA Muscat, Oman. sending to informix-list
More information will be needed to answer your question: exact version of Informix server (optional), operating system on which it runs and code pages - both for database and Windows. You will probably have to convert between two different code pages after export or unload - it depends on operating system you're using. If you're running some kind of UNIX, system utilities are usually available to convert between different code pages or you can use simple translate command. But if you're running it on Windows, then data should probably be in correct code page to be displayed in MS Excel. Gorazd <ramanu@vsnl.com> wrote in message news:bqvhka$8r9$1@terabinaries.xmission.com... > > Hi Every1. > > my client has got a data in Informix Online 5.x with r4gl used for the front end. the character based screen display in Arabic. The data stored in the field are numbers and on column is the name which is in Arabic. > > This data is exported using the unload utility to an ascii file. the data then is imported to MS-Excel. This Excel file has to sent to the Head Office of the company. But the data imported into Excel does not display the name in Arabic even though the pc has arabic installed in it. I am able to type in the same excel sheet some Arabic characters as well. > > How do I get this Informix data unloaded to be displaye in Arabic? > > Help would be greatly appreciated. > > Regards > > RAMANA > Muscat, Oman. > > sending to informix-list
I don't believe you will be able to do this via unload on the versions you've got. It 'should' work with ODBC and Win2K, depending on the exact Arabic code pages you are using. This would give you a local Excel spreadsheet which you can then send to the other office. ramanu@vsnl.com wrote: > > Hi Every1. > > my client has got a data in Informix Online 5.x with r4gl used for the front end. the character based screen display in Arabic. The data stored in the field are numbers and on column is the name which is in Arabic. > > This data is exported using the unload utility to an ascii file. the data then is imported to MS-Excel. This Excel file has to sent to the Head Office of the company. But the data imported into Excel does not display the name in Arabic even though the pc has arabic installed in it. I am able to type in the same excel sheet some Arabic characters as well. > > How do I get this Informix data unloaded to be displaye in Arabic? > > Help would be greatly appreciated. > > Regards > > RAMANA > Muscat, Oman. > > sending to informix-list -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #