My Oracle Support Banner

external table selection has truncated the last character if strings have the umlauts or tilt characters (Doc ID 2641324.1)

Last updated on MARCH 12, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 18.1.0.0.0 to 19.5.0.0.0 [Release 18 to 19]
Information in this document applies to any platform.

Symptoms

Selection from External Table returned incorrect output when data has the the umlauts or tilt characters which are upper ASCII.

The last character is truncated.

SQL> select name,lengthb(name),lengthc(name),dump(name,1017) dump from emp where name like '%IGO%MIC%' or name like '%UDA PETE%';

NAME                   LENGTHB(NAME)  LENGTHC(NAME)  DUMP
-------------------- ------------------ ------------------ ------------------------------------------------------------
ŽIGO MICHA                            11                    10  Typ=1 Len=11 CharacterSet=UTF8: c5,bd,I,G,O, ,M,I,C,H,A
ŠIKUDA PETE                           12                     11  Typ=1 Len=12 CharacterSet=UTF8: c5,a0,I,K,U,D,A, ,P,E,T,E

+++
The correct one is

NAME                   LENGTHB(NAME) LENGTHC(NAME) DUMP
-------------------- ------------------ ------------------ ------------------------------------------------------------
ŽIGO MICHAL                          12                    11 Typ=1 Len=12 CharacterSet=UTF8: c5,bd,I,G,O, ,M,I,C,H,A,L
ŠIKUDA PETER                         13                    12 Typ=1 Len=13 CharacterSet=UTF8: c5,a0,I,K,U,D,A, ,P,E,T,E,R

Changes

Upgraded to 18c or 19c

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.