Re: Character Sets in 11g

From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>
Date: Thu, 16 Jan 2014 18:00:25 -0400
Message-ID: <CAGYrQyv+_AoR4HQ3i28YOGfZAknVn7o3rBGVMPvQG1mE4z3Kug_at_mail.gmail.com>

I don't understand what are latin characters, but if latin characters are spanish accented characters, ñ, portugues, etc.

This configuration supports that
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16 CREATE DATABASE xxx
CONTROLFILE REUSE
LOGFILE

GROUP 1 ('D:\oraxxx\logfiles\log_1xxx.ora',
'E:\oraxxx\logfiles\log_1xxx.ora') SIZE 200M,
GROUP 2 ('D:\oraxxx\logfiles\log_2xxx.ora',
'E:\oraxxx\logfiles\log_2xxx.ora') SIZE 200M

MAXLOGFILES 32
DATAFILE 'E:\oraxxx\datafiles\dfl_sys_xxx'

   size 200M
   REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED    EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TBL_TEMP TEMPFILE 'D:\oraxxx\datafiles\DFL_TEMP_xxx'

   SIZE 50M
   REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 640K UNDO TABLESPACE TBL_UNDO DATAFILE 'E:\oraxxx\datafiles\dfl_undo_xxx'

   SIZE 100M
   REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED MAXLOGHISTORY 1
MAXLOGFILES 3
MAXLOGMEMBERS 3
MAXDATAFILES 15
MAXINSTANCES 1
ARCHIVELOG
EXCLUSIVE
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
;

2014/1/16 Chris King <ckaj111_at_yahoo.ca>

> I'm trying to understand an instruction the following instructions from an
> application installation guide. It says:
>
> If the database is configured for the UTF8 or AL32UTF8 character set
> (NLS_CHARACTERSET parameter) in a LATIN-1 locale, and the CHAR schema is
> used as an underlying persistent schema, set the NLS_LENGTH_SEMANTICS
> parameter of the database to CHAR to prevent column field overflow.
>
> I'm using UTF8 and AL32UTF8 with America (language), American (territory).
> Is this considered a Latin-1 locale?
>
> I'm somewhat confused because we typically use the western characterset,
> which I know includes latin characters. But I think locale refers to the
> language and territory?
>
> Also how do I determine what the underlying persistent schema is?
>
> I can't just set NLS_LENGTH_SEMANTICS to CHAR unless it's necessary, as I
> have a conflicting requirements from another application which will share
> this database, so understanding this will be key to how I set up the
> database(s).
>
> Thanks in advance!
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 16 2014 - 23:00:25 CET