Home » SQL & PL/SQL » SQL & PL/SQL » Character Set in Oracle
Character Set in Oracle [message #251840] Mon, 16 July 2007 18:26 Go to next message
maheshap
Messages: 2
Registered: July 2007
Junior Member
I am writing a C++ application which asks the users to enter the database name and presents a list of Character sets available in Oracle. Then the application creates the database with the user specified name and the character set.

Problem is how do I get the list of Character Sets in Oracle without connecting to a database.

I tried by sending the request packets to tns listener, but there is no command which gets the Character sets.

The command SELECT UNIQUE VALUE FROM V$NLS_VALID_VALUES WHERE PARAMETER ='CHARACTERSET'; needs an active database connection to get the character sets.

Re: Character Set in Oracle [message #251841 is a reply to message #251840] Mon, 16 July 2007 18:31 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>Then the application creates the database
Are you really, really going to issue CREATE DATABASE from a C++ application?
If so, what is the name of the data architect that came up with this "design"?

What happens if/when the wrong characterset is specified?
Do you expect a user to intelligently select from the following?

VALUE
----------------------------------------------------------------
SF7DEC
TR7DEC
WE8EBCDIC1148
EE8ISO8859P2
EL8ISO8859P7
TH8TISASCII
BLT8ISO8859P13
EL8DEC
IW8EBCDIC424
EE8MSWIN1250
BLT8CP921
LV8RST104090
D7SIEMENS9780X
WE8GCOS7
D8BS2000
F8BS2000
DK8BS2000
US8ICL
CL8EBCDIC1158R
EL8EBCDIC423R
WE8MACROMAN8
HU8CWI2
AR8ADOS710
AR8APTEC715
LA8ISO6937
JA16EUCYEN
ZHS16GBK

247 rows selected.

[Updated on: Mon, 16 July 2007 19:05] by Moderator

Report message to a moderator

Re: Character Set in Oracle [message #251843 is a reply to message #251841] Mon, 16 July 2007 19:38 Go to previous messageGo to next message
maheshap
Messages: 2
Registered: July 2007
Junior Member
From C++, .ora files will be created which will have the required commands to create the database and this .ora file will be sent as parameters to the sqlplus.exe.

User can't select the wrong character set because he has to select it from a list of prepopulated items.

Re: Character Set in Oracle [message #251848 is a reply to message #251840] Mon, 16 July 2007 20:45 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
If all character sets are equal & a wrong character set can't be selected, then why does the user have to pick 1 out of a list?
Why can't the application just use the same character set for all DB?

>User can't select the wrong character set because he has to select it from a list of prepopulated items.
Then your problem is solved.

My experience says that what you plan on doing is going to lead to MAJOR support problems in the future.

In all the years I've been dealing with Oracle & I have never known of an application that builds new database based upon end user input & request.

I can NOT think of any legitimate business requirement to do so.

You're On Your Own (YOYO)!

[Updated on: Mon, 16 July 2007 21:01] by Moderator

Report message to a moderator

Previous Topic: About 'ORA-02292' Error
Next Topic: SQL query Problem
Goto Forum:
  


Current Time: Mon Dec 05 21:03:04 CST 2016

Total time taken to generate the page: 0.05354 seconds