chr function

When using the chr function on values 127 and beyond, it appears to return only one value, as if the last char in the character set is 127. This is happening on a HP-UX running an Oracle 8.0. However, it gives a different result when tried with an aix system on oracle 8.0 [ I can go all the way upto 255 ]. I believe this has nothing to do with the oracle and unix system, but some setup for oracle is making this. Can you please tell me what is that setting that I am missing?

I think this depends on two things
(1) The operating system - the character set
supported by it.
(2) The front end used to execute the query,
for example sqlplus, or plus33w...

- Vish

0

mmanjuAuthor Commented: 2000-02-18

Thank you for your answers. Is there any way of finding the nls_character_set in oracle? I tried looking for all entries where name like '%nls%' under v$parameter, but could not find anything that said nls_character_set. Is there any other place where I can find it?

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Normally only the first 128 characters are usually used. The next 128 chratcters are called as extended characters and are only used by some east asian languages (eg. japaneese).

0

mmanjuAuthor Commented: 2000-02-19

Thank you for that. But, my question is what setting is making one system of same oracle version be able to use all 255 characters and other use only first 127 of the same. Any suggestions would be greatly appreciated.

manju, you have to accept the answer and give the expert the points failing which , you may not get answers to your future Qs.

0

mmanjuAuthor Commented: 2000-02-25

EXCUSE ME GUYS. I ONCE AGAIN, JUST FOR CLARIFICATION, I DID CHOOSE THE "ACCEPT COMMENT AS ANSWER" BUTTON AND I DONT KNOW WHY ITS NOT GETTING REPORTED. DID SOMETHING CHANGE? ONCE AGAIN SORRY ABOUT THIS, AND IS THERE A SEPERATE ACCEPT ANSWER THAT I HAVE TO USE?

Featured Post

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!