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