Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

extended characters in UNIX

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting extended characters in UNIX
# 1  
Old 11-12-2009
extended characters in UNIX
Hi Guys,
I am using db2 load to load from a csv file to a table.
Problem is that extended characters ™,®,é,º do not get loaded correctly.
Its a UTF 8 format csv and i am using codepage=1208 for the load.
Does anybody have an idea on this?
Thanks
# 2  
Old 11-17-2009
How do you load the data? You have provided no information expect that you have a DB2, csv with UTF-8 and possibly an undefined problem.
# 3  
Old 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.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extended ASCII Characters keep on getting reintroduced to text files

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

2. Programming

How to read extended ASCII characters from stdin?

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

3. Shell Programming and Scripting

Search and Replace Extended Ascii Characters

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

4. Shell Programming and Scripting

Identify extended ascii characters in a file

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

5. UNIX for Dummies Questions & Answers

Control characters in UNIX

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

6. Linux

string characters in UNIX

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

7. Solaris

how to disable extended desktop in unix

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

8. Shell Programming and Scripting

Working with extended keyboard characters

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

9. Shell Programming and Scripting

how can i increment characters in unix.. ?

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

10. UNIX for Advanced & Expert Users

Processing extended ascii character file names in UNIX (BASH scipts)

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
Login or Register to Ask a Question