Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Create Database with character set AL32UTF8

DKuttMar 1 2012 — edited Mar 2 2012
I'm running in a problem trying to set up an Oracle 11.2.0.3.0 Database with AL32UTF8 as Character Set and National Character Set under SLE10_64bit SP3.

I run a crdb.sql skript through sqlplus, but encounter this error:

ERROR:
ORA-06550: line 1, column 29:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated

The skript I run:

####

connect SYS/abcpass as SYSDBA
set echo on
spool /ora/app/oracle/admin/ABC/create/CreateDB.log
startup nomount pfile="/ora/app/oracle/adin/ABC/pfile/initABC.ora";

CREATE DATABASE ABC
MAXINSTANCES 4
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL32UTF8
NOARCHIVELOG
DATAFILE '/u01/oradata/ABC/system01.dbf' SIZE 700M
AUTOEXTEND ON
MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oradata/ABC/sysaux01.dbf' SIZE 600M
AUTOEXTEND ON NEXT 1G
MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oradata/ABC/temp01.dbf' SIZE 700M AUTOEXTEND ON
EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/oradata/ABC/undotbs01.dbf' SIZE 1000M
LOGFILE GROUP 1 ('/u01/oradata/ABC/redo01m1.dbf',
'/u01/oradata2/ABC/redo01m2.dbf') SIZE 500M,
GROUP 2 ('/u01/oradata/ABC/redo02m1.dbf',
'/u01/oradata2/ABC/redo02m2.dbf') SIZE 500M,
GROUP 3 ('/u01/oradata/ABC/redo03m1.dbf',
'/u01/oradata2/ABC/redo03m2.dbf') SIZE 500M,
GROUP 4 ('/u01/oradata/ABC/redo04m1.dbf',
'/u01/oradata2/ABC/redo04m2.dbf') SIZE 500M;
spool off
exit;

####

NLS_LANG ist set to AMERICAN_AMERICA.AL32UTF8.

If I try to set up the Database with Char-Set and NChar-Set as UTF8 it works...
I realize it is probably a simple beginner error, but would welcome advice even more so because of that.

Edited by: user12059122 on 01.03.2012 09:08

Comments

Hi,

Welcome to OTN. The behavior you are noticing is expected. If you would like to display a custom exception/convertor, check out this doc.

http://docs.oracle.com/cd/E25178_01/web.1111/b31973/af_validate.htm#BABGIEDH

-Arun
SantoshVaza
Hi,
have an af:table with the filtering enabled
on corrosponding field add af:convertNumber tag like 
<af:inputText>
            <af:convertNumber/>
</af:inputText>
So instead of throwing exception it will prompt the user to add a numeric value..

Regards,
User794216-Oracle
Thanks for the replies.
I was aware of those "fixes" except that

- users need to be able to use < or > in the filter criteria, so restricting them to numbers is not a solution
- the custom implemenation is a lot of work for something I would expected ADF to deal with.

I don't get the number exception when I enter "> 100" or "< 100" so the < and > seem to pass succesfully.
But if by accident I enter "= 100" instead of "100" it throws the number exception
So I still feel this should be handled more gracefully out of the box.

Thanks, Ingrid
Here is a simple workaround that I make use of, might help!

Consider I have a bind variable searchString of String type being used in a view criteria. View criteria has a numeral attribute as well as text attribute to compare with :searchString. Now what I do to avoid the exception is that I create another bind variable called searchStringForInt of String type. I set the value of this bind variable as expression type "+searchString != null ? searchString.replaceAll("\\D+","") : null+" and use this :searchStringForInt for comparing with numeral attribute instead of :searchString.
Also FYI, QBE behaviour can be customized. Take a look at http://radio-weblogs.com/0118231/stories/2003/07/11/implementingAViewCriteriaAdapterToCustomizeQueryByExampleFunctionality.html.
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 30 2012
Added on Mar 1 2012
#11g, #database-key-features, #globalization-support
3 comments
8,962 views