Database Administration (MOSC)

MOSC Banner

Query to show the Bits that comprise a VARCHAR2 value

I'm running Oracle Enterprise DB 19c. I'm having an issue with client/DB charsets and encoding. In short, I need to validate the data in an VARCHAR2  column in a table to see that it is valid. The data is a string/VARCHAR2 at the DB end. We have had issues where the Irish Fada has been written to the DB by one client but when retrieved is displayed as another character.

Due to the various client local and NLS_LANG settings the easiest way to do this would be to retrieve this string and list the bits that comprise it as simply viewing it means I need to check all the client local/NLS_LANG settings.

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