NCharSetID

[wardy]

Hi all,

Can someone tell me where this setting is amended? On some clients we have it set to 0 and others its set to 2000. We are seeing issues with pound signs being converted / displayed as a hash sign and this setting appears to be the only thing that is different

Cheers

 

[Marco Kalter]

The NCHAR character set is defined at database creation time. When connected to the same database the NCharSetID should be the same on different PC's.

 

[wardy]

Thanks for the reply however i dont think its correct. Help > Oracle info is below from two different machines to the same database

This one works
Character Sets
Character size: 1 byte(s)
CharSetID: 31
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: WE8ISO8859P1

This one doesnt
Character Sets
Character size: 1 byte(s)
CharSetID: 31
NCharSetID: 0
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: WE8ISO8859P1

Any other thoughts as to why pound signs return as hash? Good old SQL PLUS works fine by the way on both machines

 

[IvanZ]

Hi

NCharSetID: 0
means that PLD failed to get some NLS information from the database.

Start PLD with DebugSQL modifier and look at what queries it runs.
Most likely it's connection specific, not machine specific.

 

[wardy]

Ran both machines with debug and they both have the same result for NLS

26/04/2018 08:38:02 TOracleQuery $03A6C040 Start Query.Execute
SQL = select * from nls_database_parameters where parameter like 'NLS%CHARACTERSET'
26/04/2018 08:38:02 TOracleQuery $03A6C040 End (2 records processed)

There's a lot of info any under debug , any pointers to check specifics? I have found on the machine that doesn't work the following
26/04/2018 08:37:57 TOracleQuery BytesPerCharacterQuery End
Result = Error while trying to retrieve text for error ORA-24329

 

[Marco Kalter]

The "Error while trying to retrieve text for error ORA-24329" indicates that there may be an Oracle Client installation issue. You may want to uninstall/reinstall the Oracle Client, or, if you have multiple Oracle Client installations, go to Preferences > Oracle / Connection and select a different home from the "Oracle Home" selection list.