My Oracle Support Banner

Character Replacement Upside Down Question Mark ¿ Using SQL Loader (SQLLDR) Example: Eastern European Character(s) ł Ł (Doc ID 2611980.1)

Last updated on NOVEMBER 29, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.3 and later
Information in this document applies to any platform.

Symptoms

There are many variations to the problem of loading data into a database using SQL*Loader ( SQLLDR ) or dbms_put which can result in a replacement character which does not represent the original physical character.
This problem can occur for any string / char / varchar data including addresses, names of products, description fields...basically any text field.
This problem is also generic to any data being transported into a database where a potential mismatch of characters exists between character sets.

In this case the problem was seen for a person's name, stored and then read from an application.

 Last_name , First_name

In this example we will use the following as the user name

First Name: ABC..

Last Name: Z....¿    <<

 

 

select first_name,last_name from <some_table>;

FIRST_NAME LAST_NAME
---------- ---------------
ABC.....       Z....¿....


Changes

Loading text data from a new geographical region for the first time.
The character data from this new region included characters being loaded for the first time.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.