Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When I am using the WebLogic jDriver for Oracle driver with my Oracle database, how can I find out what foreign language codesets I can access and use?

April 26, 2017codesets driver foreign jDriver Language Oracle oracle database WebLogic

0

Posted

When I am using the WebLogic jDriver for Oracle driver with my Oracle database, how can I find out what foreign language codesets I can access and use?

1 Answer

0

Posted

To find out what codesets you currently have available in Oracle, execute the following SQL query from SQLPlus at the command line: SQL> SELECT value FROM v$nls_valid_values WHERE parameter=’CHARACTERSET’; The response will be a listing of all of the codesets currently installed on your system. This listing will look something like the following shortened list: VALUE ———————————————————– US7ASCII WE8DEC WE8HP US8PC437 WE8EBCDIC37 WE8EBCDIC500 WE8EBCDIC285 … If you want to constrain the value in the query to a specific codeset you are searching for, you might use a SQL query like the following: SQL> SELECT value FROM v$nls_valid_values WHERE parameter=’CHARACTERSET’ and VALUE=’AL24UTFFSS’; This would produce the following response if the codeset is installed: VALUE ————————————————————- AL24UTFFSS Additional codesets can be added using Oracle’s installation tools. Contact Oracle for more information.