How to deal with accents?

I've run into an issue where PLSQL Developer isn't acting how I would expect it to act.

When I do the following Query in PLSQL Developer
Code:
SELECT
  DUMP('ć', 1016) AS dump_hex,
  LENGTH('ć')     AS len
FROM dual;
It's returning
Typ=96 Len=1 CharacterSet=AL32UTF8: 63 1
But, it's a Unicode character, so it should look like the following (this is what SQL Developer returns)
Typ=96 Len=2 CharacterSet=AL32UTF8: c4,87 1

I can't figure out how to get PLSQL Developer to look at accent characters as accent characters. The overall issue is the database is storing people's names with accents and unless I use this cludgy where statement instead it doesn't work in the database, which is also problematic, b/c it returns every person with a c in their first name.
NLSSORT(s.FIRST_NAME, 'NLS_SORT = BINARY_AI') like NLSSORT('%ć%', 'NLS_SORT = BINARY_AI')

Just using SQL Developer I can do this and it works properly
s.FIRST_NAME like '%ć%'

This is what the PLSQL Developer Support info says for character set
Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG:
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

I've tried changing the params.ini to include the following, but it didn't change the support info, or how oracle works (I saw this in an old post somewhere)
NLS_LANG = AL32UTF8

Any help would be appreciated.
 
Back
Top