Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

SQL into UNIX\Oracle - European Characters

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers SQL into UNIX\Oracle - European Characters
# 1  
Old 04-27-2005
SQL into UNIX\Oracle - European Characters
Hi All! I'm new to Unix\Oracle but have been working with MS SQL Server for 8 years. I'm in the process of migrating data from MS to Oracle and have hit a problem.

Some of the information I'm porting over has the following characters in it: ü and Ö to show a few. I'm able to export them out of MS SQL Server without any issues but on the FTP over to the UNIX server they are displayed (using vi to look at it) as so respectively: \37 and \326. If I use SQL Loader and import the file into Oracle, all of those european type letters then show up in Oracle as upside down ? (question marks).

I'm guessing that it might have something to do with the way UNIX is configured, or the way FTP is handling the copy process (tried both ascii and binary file transfers and either worked) but I'm not sure what or where to look? Any suggestions would be appreciated.

Thanks for your help in advance.
Patty Hernon
Smilie
# 2  
Old 04-28-2005
Two issues.

Oracle has NLS settings for handling extended characters - this needs to be configured, ask your DBA.

Unix has locale settings try
Code:
man locale

# 3  
Old 04-28-2005
You may have to use adncnv, see http://download-east.oracle.com/apps.../r1155adux.pdf
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

Hi all, $ echo $SHELL /bin/bash Requirement - How to pass oracle sql script as argument to unix shell script? $ ./output.sh users.sql Below are the shell scripts and the oracle sql file in the same folder. Shell Script $ cat output.sh #!/bin/bash .... (7 Replies)
Discussion started by: a1_win
7 Replies

2. What is on Your Mind?

UNIX field scope in European countries

Hi, I have been working in India since past 13 years and as per Indian IT culture, there will be saturation in Salary which barely matches with rising living costs in India. I am thinking to move/work in some other country for few years at least which help me financially plus technically. As of... (3 Replies)
Discussion started by: nightup2222
3 Replies

3. UNIX for Advanced & Expert Users

Use of Oracle pl/sql in UNIX shell script

Hi, I have basic knowledge on how to write pl/sql code inside shell script. I am looking for more advance thing. Is there any book for that which can just talk about how to write more advance plsql code inside shell script. Please help Thanks!!!!!! (1 Reply)
Discussion started by: diehard
1 Replies

4. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks (1 Reply)
Discussion started by: tdev457
1 Replies

5. Programming

SQL Oracle error

Am trying to run this : DECLARE CURSOR c1 IS SELECT customer_id, num3 FROM table1 WHERE text1 = 'pp' AND customer_id IS NOT NULL; custcount INTEGER; oldtext24 VARCHAR2 (80); commit_counter INTEGER := 0; BEGIN FOR i IN c1 ... (1 Reply)
Discussion started by: maiooi90
1 Replies

6. UNIX and Linux Applications

Free UNIX with ksh, perl, Oracle and SQL

Is there a UNIX with ksh, perl, Oracle an SQL to download for free? If not, how can I "build" one? (9 Replies)
Discussion started by: Sygonion
9 Replies

7. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies

8. Shell Programming and Scripting

Executing a Oracle SQL statement in a UNIX script

Hi All, I need to select one column from a table based upon the passed in parameter. I tried this: sqlplus -silent $MISP_USER << EOF set feedback off; set verify off; set sqlprompt "" SELECT mail_flag FROM dailyjobs WHERE job_name = '$1'; exit 0 EOF exit... (1 Reply)
Discussion started by: ganga.dharan
1 Replies

9. Shell Programming and Scripting

Unix call to Oracle PL/SQL pkg/store.proc

HI, I'm trying to get this right, please can you help. In my unix korn shell script, I call an oracle stored proc within a package and I specify 3 parameters, 2 of which are IN OUT parameters (i.e. I expect the stored proc to change them and return them back to me). Does the unix code... (7 Replies)
Discussion started by: csong2
7 Replies

10. UNIX for Dummies Questions & Answers

how to pass values from oracle sql plus to unix shell script

how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies
Login or Register to Ask a Question