I'm facing issue while opening xls file while contains Russian/Siberian character
I tried various options which I could get from google but still issue persists hence thought of taking help here,
We are trying to export data from Oracle via shell script using sqlplus utility. After setting below 2 env variable,
And opening the file via "more" command I could see proper value,
But If I try to view it using "vi", I'm getting below value,
And after opening the excel file I could see below value,
Excel :
I wanted the excel sheet to display proper value. Any suggestion please.
Thanks,
Arvind.
Moderator's Comments:
Please use code tags as required by forum rules for data as well.
Last edited by RudiC; 05-09-2016 at 03:20 AM..
Reason: Added code tags for data
LC_ALL="en_US.iso88595" is an unusual locale name. On my system, there are locales named be_BY.ISO8859-5, ru_RU.ISO8859-5, sr_YU.ISO8859-5, and uk_UA.ISO8859-5; but none that use 88595 without a hyphen and none that use the ISO 8859-5 codeset for an English language locale.
To get a list of the locales that are available on your system, issue the command:
and to limit it to locales using 8859-5, try:
8859-5 character encoding is not present in system. Hence I tried setting
and
and if i open output file generated shows me proper values with
command but when I send the file as attachment using
command. Excel still shows me weird character. What could be wrong.
I tried iconv with various character set but it didn't help. After setting char type as UTF-8. If i check file type its shows
. Not sure if this information helps. Also I was thinking do I need to perform similar setting while sending mail via
command.
is not present on my system hence unable to check.
Hi All,
I'm having trouble exporting Russian characters from Oracle database via shell Script. I'm setting below value in script,
NLS_LANG=RUSSIAN_CIS.CL8ISO8859P5
Also in terminal setting of Tectia value for Euro character I'm selecting "ISO-8859-15 (0xA4)" and other value was "Windows... (2 Replies)
Hello,
I created the following (snippet from larger code):
echo -n "A1: "
read A1
VERIFY=$(echo -n $A1|wc -c)
if ; then
echo -e "TOO MANY CHARACTERS"
fi
echo -n "A2: "
read A2
echo -n "A3: "
read A3
echo -e "Concat: $B1/$B2/$B3"
Basically what it does is it... (4 Replies)
Hi,
I'm trying to edit a file with vi, but all special characters (áéíóú etc) don't seem to show correctly. They don't seem to be supported by the OS (SunOS 5.10).
I'm using MobaXterm as the terminal emulator, which is configured to use ISO-8859-1. The same charset is used on Solaris.
If I open... (4 Replies)
dears
i am using solaris 10
i am facing a problem when i make setup for solaris i choose the country egypt and i select the language north america
but i forget to do that the i found the date Jun written in arabic
i want to change character set to written in english
-rw-r--r-- 1 root ... (4 Replies)
Hi,
Could anybody explain how to change the character set of a particular string in C in unix. we are using HP-UX as OS. We require to change the input string which is in cp1250 format to utf-8.
A sample code would help. Thnx in advance (1 Reply)
I am forced to use the ANSEL character set for some GEDCOM documents but must convert them to a more modern set for another app which doesn't recognize ANSEL. I am unable to locate an ISO code for ANSEL in a search of the web. Would someone plese identify the ANSEL character set from the list given... (4 Replies)
hi ,
i am trying to work on a script that transforms some special Dutch characters and send them to a Xerox printer ..
the problem is that while doing so iam unable to identify th correct character set that is used by solaris , to transfer these characcters to Xerox character set .
thanks... (2 Replies)
Hi,
We have problems with the latin 2 Character-set with xterm.
We have installed SunRay-Server with Solaris 8. Our Thinclients use hu- and cz-keyboards. I have set the right local-settings and xmodemaps. If I use the dtterm all is running fine. As soon as I use the xterm, it cannot display... (0 Replies)