Diferencias entre los CharacterSet WE8ISO8859P1 y WE8MSWIN1252

Según oracle tenemos que el characterset definido en WE8ISO8859P1 es un “subgrupo” del characterset WE8MSWIN1252, es decir que este ultimo posee characters adicionales al primero.

Hilando un poco más fino, podemos decir que el characterset WE8MSWIN1252 posee 27 caracteres adicionales.

A continuación vemos la lista con las 27 diferencias:

Win-1251	Unicode Char	Charact	Descripción
0x80	0x20AC	[€] [€]	EURO SIGN
0x82	0x201A	[‚] [‚]	SINGLE LOW-9 QUOTATION MARK
0x83	0x0192	[ƒ] [ƒ]	LATIN SMALL LETTER F WITH HOOK
0x84	0x201E	[„] [„]	DOUBLE LOW-9 QUOTATION MARK
0x85	0x2026	[…] […]	HORIZONTAL ELLIPSIS
0x86	0x2020	[†] [†]	DAGGER
0x87	0x2021	[‡] [‡]	DOUBLE DAGGER
0x88	0x02C6	[ˆ] [ˆ]	MODIFIER LETTER CIRCUMFLEX ACCENT
0x89	0x2030	[‰] [‰]	PER MILLE SIGN
0x8A	0x0160	[Š] [Š]	LATIN CAPITAL LETTER S WITH CARON
0x8B	0x2039	[‹] [‹]	SINGLE LEFT-POINTING ANGLE QUOTATION MARK
0x8C	0x0152	[Œ] [Œ]	LATIN CAPITAL LIGATURE OE
0x8E	0x017D	[Ž] [Ž]	LATIN CAPITAL LETTER Z WITH CARON
0x91	0x2018	[‘] [‘]	LEFT SINGLE QUOTATION MARK
0x92	0x2019	[’] [’]	RIGHT SINGLE QUOTATION MARK
0x93	0x201C	[“] [“]	LEFT DOUBLE QUOTATION MARK
0x94	0x201D	[”] [”]	RIGHT DOUBLE QUOTATION MARK
0x95	0x2022	[•] [•]	BULLET
0x96	0x2013	[–] [–]	EN DASH
0x97	0x2014	[—] [—]	EM DASH
0x98	0x02DC	[˜] [˜]	SMALL TILDE
0x99	0x2122	[™] [™]	TRADE MARK SIGN
0x9A	0x0161	[š] [š]	LATIN SMALL LETTER S WITH CARON
0x9B	0x203A	[›] [›]	SINGLE RIGHT-POINTING ANGLE QUOTATION MARK
0x9C	0x0153	[œ] [œ]	LATIN SMALL LIGATURE OE
0x9E	0x017E	[ž] [ž]	LATIN SMALL LETTER Z WITH CARON
0x9F	0x0178	[Ÿ] [Ÿ]	LATIN CAPITAL LETTER Y WITH DIAERESIS

Esto quiere decir que si necesitamos utilizar por ejemplo el simbolo del Euro y nuestra base esta configurada en P1 deberiamos modificar el characterset de la base siguiente los siguientes pasos:

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP MOUNT;

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL> Alter DATABASE OPEN;

SQL> ALTER DATABASE CHARACTER SET WE8MSWIN1252;

SQL> SHUTDOWN IMMEDIATE;

SQL> STARTUP;

Espero les haya servido.

Saludos!
Gondalf