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 APRIL 17, 2023

Applies to:

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


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>;

---------- ---------------
ABC.....       Z....¿....


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.


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

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