Database Administration (MOSC)

MOSC Banner

Flashback Data Archive not working multibyte character set UTF8 when data exceeds byte length

in Database Administration (MOSC) 4 commentsAnswered

We are on 19.6.0.0.0 and have a problem with FBDA not storing history rows for fields that exceeds length that looks like below in Bug 20350312

1) multibyte character set like UTF8 or AL32UTF8 is used AND

2) multibyte characters are being used in the VARCHAR2(... CHAR) column AND

3) the defined width is exceeded, considering that multi-byte characters

use more than 1 byte, e.g. "N??tzlichkeitsanalyse" which is 20 charlong but uses 21 bytes

 We have the NLS_LENGTH_SEMANTICS set to char in our databases.

I  can't see any ORA errors in the alert log though.

I can reproduce this behaviour in our testdatabases.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center