NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET both set to UTF8 ?



Hello,
I have a problem with Oracle 9.2.0.6.0 on Unix.
Is it possible to set (when database is created) both parameters:
NLS_NCHAR_CHARACTERSET as UTF-8
NLS_CHARACTERSET and UTF-8
?
Database administrator told me that when he created database with
NLS_CHARACTERSET = UTF-8
then
NLS_NCHAR_CHARACTERSET is always set to AL16UTF16 and it can not be
changed to UTF-8 ?

Application which I tried to install required
UFT-8 set on both NLS_NCHAR_CHARACTERSET and NLS_CHARACTERSET

Thank you
Regards,
Mariusz /MANIEK/

.



Relevant Pages

  • Re: Creating XML from an Oracle DB
    ... answer to what must be a FAQ when generating XML from Oracle but I ... an Oracle 9.2 database using DBMS_XMLQUERY and DBMS_LOB. ... Oracle's utf-8 support for the XML packages is shameful. ... You can determine your database's character set with this query: ...
    (perl.dbi.users)
  • Re: utf-8 support in libc?
    ... language) it doesn't matter how the database is encoded, ... I'm not sure if that is a BSD issue or a Postgres issue for not taking advantage of the BSD functions properly. ... there is no collation support for UTF-8 on those platforms. ... locale you initdb with is a UTF-8 locale. ...
    (freebsd-stable)
  • Re: national characters not printed
    ... I have configured MySQL and PHP5. ... I have created 'books' table in test ... database with utf-8 set for database and table. ... utf-8 compatible and also your html must set to utf-8. ...
    (comp.lang.php)
  • RE: LANG system environment variable
    ... So, if I understand you correctly, I would be better off leaving the system the way it is and change the database data to UTF-8? ... > character set the other expects. ... > to store umlaut characters and accents. ...
    (Fedora)
  • Ubuntu encodings
    ... Looking at the database setup I found all the databases had been created ... with UTF-8 encoding, although I do not recall any indication in the ... setup or configuration that implied or stated that UTF-8 was going to be ... Ubuntu chooses UTF-8 as the default, ...
    (Ubuntu)