Database Administration (MOSC)

MOSC Banner

Output Spanish from us7ascii clob table?

I have a clob table where some of our users are entering Spanish characters that aren't pulling right from our sql -- like ascii 150 ú. It will show a ┐ in SQL Plus and ヨ in our ORDS output. If I use the function ascii, it tells me it is 150.

I tried convert(my_string,'us7ascii','utf8') and it shows a question mark.

The db NLS_NCHAR_CHARACTERSET is UTF8 and the NLS_CHARACTERSET is US7ASCII. I tried converting the column from a CHAR to NCHAR and the existing data doesn't do anything different.

Is there anything I can do to that column or is there some sort of conversion ability that I can use so my REST Data Services and other applications display non-English characters?

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