Randomized_J
Member
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
It's returning
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.
Just using SQL Developer I can do this and it works properly
This is what the PLSQL Developer Support info says for character set
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)
Any help would be appreciated.
When I do the following Query in PLSQL Developer
Code:
SELECT
DUMP('ć', 1016) AS dump_hex,
LENGTH('ć') AS len
FROM dual;
But, it's a Unicode character, so it should look like the following (this is what SQL Developer returns)Typ=96 Len=1 CharacterSet=AL32UTF8: 63 1
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.