11-17-2009
I don't know DB2, but in ORACLE there is an environment variable called NLS_LANG that you set to the characterset the data was generated in when the file was created. This allows Oracle to convert the characters to the database characterset when storing it in the database. The code page of your operating system doesn't matter. The database has to know what characerset the DATA was created in. You might check to see if DB2 handles charactersets similarly.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi, I have a accentuated letter (ö) in a script for an Installer. It's a file name. This is not working and I'm told to try using the octal value for the extended ascii character. Does anyone no how to do this? If I had the word "filförval", can I just put in the value between the letters, like... (9 Replies)
Discussion started by: peli
9 Replies
2. Shell Programming and Scripting
hi..
i am having some 3 files : ka, kb, kc
i want to use these set of files in my script... how can i do that ?
like first it should process "ka" .. then "kb".. then "kc" ...
thanks,
Krips. (3 Replies)
Discussion started by: kripssmart
3 Replies
3. Shell Programming and Scripting
I will be reading a file (file_in) with name & address and a word that I may need to convert. Running unix on a pc, this would be easy. But on my Solaris I am not getting the desired results.
If my file_in contains:
Joe|Smith|123 Main Street|E|Vehicle
Nicky|Dufour|1 Ste. Catherines|F|Vehicle... (1 Reply)
Discussion started by: joeyg
1 Replies
4. Solaris
hi guys,
i have a unix WS ultra45, I installed sol10 after that I found the screen is extended to second screen , any one knows how to disable that ? (4 Replies)
Discussion started by: dagigg
4 Replies
5. Linux
I need some help.
when i use the following command, it deletes all lines containing WINNT& v2010 and WINNT& v2010.2
I just want it to delete lines containing WINNT & v2010 only.
perl -n -i.bak -e 'print unless /WINNT/&&/v2010/' *.*
Danish (2 Replies)
Discussion started by: sdanish110
2 Replies
6. UNIX for Dummies Questions & Answers
Hi,
My files are showing some control characters in vi editor
^M
^@ and somtimes
^H
I removed ^M with %s/^M//g command
but how to represent ^@ and ^H
e.g. for ^M it is hold ctrl then v and m..
Please help..
I am very new to unix.. (7 Replies)
Discussion started by: prabhat.diwaker
7 Replies
7. Shell Programming and Scripting
Hi,
Is there a way to identify the lines in a file having extended ascii characters and display the same?
For instance I have a file abc.txt having below data
aaa|bbb|111|This is first line
aaa|bbb|222|This is secõnd line
aaa|bbb|333|This is third line
aaa|bbb|444|This is foùrth line... (3 Replies)
Discussion started by: decci_7
3 Replies
8. Shell Programming and Scripting
We are getting extended Ascii characters in the input file and my requirement is to search and replace them with a space. I am using the following command
LANG=C sed -e 's// /g'
It is doing a good job, but in some cases it is replacing the extended characters with two spaces. So my input... (12 Replies)
Discussion started by: ysvsr1
12 Replies
9. Programming
Hi,
I want to read extended ASCII characters from keyboard using c language on unix/linux. How to read extended characters from keyboard or by copy-paste in terminal irrespective of locale set in the system. I want to read the input characters from keyboard, store it in an array or some local... (3 Replies)
Discussion started by: sanzee007
3 Replies
10. Shell Programming and Scripting
I am working with a log file that I am trying to clean up by removing non-English ASCII characters. I am using Bash via Cygwin on Windows.
Before I start I set:
export LC_ALL=C
I clean it up by removing all non-English ASCII characters with the following command;
grep -v $''... (4 Replies)
Discussion started by: lewk
4 Replies