Database Administration (MOSC)

MOSC Banner

We have german-umlaut characters stored in a BLOB field.

edited Feb 13, 2019 4:05AM in Database Administration (MOSC) 6 commentsAnswered

We have german-umlaut characters stored as a BLOB.  For example we store this text in the field:  Hohe TAN. Das Öl ist bedingt gebrauchsfähig. Ölwechsel bei Probenahme: Ja

When we use the statement below to extract the text:

select UTL_RAW.CAST_TO_VARCHAR2(dbms_lob.substr(BLOB_FIELD,100,2))

  from BLOB_VALUES

  where BLOB_ID = 319905;

It returns instead of the way it was entered/stored:

"ohe TAN. Das � ist bedingt gebrauchsf�g. �wechsel bei Probenahme: Ja"

Our character set are:

NLS_NCHAR_CHARACTERSET - AL16UTF16

NLS_CHARACTERSET - AL32UTF8

What have done incorrect to retrieve the data?  Is there some other character set we need to use?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center