Difference between WE8MSWIN1252 and WE8ISO8859P1 characterset

The definition of both sets can be found here:
———————————————-

The MSWIN1252 characterset
http://www.microsoft.com/globaldev/reference/sbcs/1252.htm
The ISO 8859P1 characterset
http://www.microsoft.com/globaldev/reference/iso/28591.htm

The difference between the 2 charactersets:
——————————————-
* 27 codepoints are NOT existing in P1 that are filled in / used in WE8MSWIN1252

(note that the WE8MSWIN1252 codepoints
91 = U+2018 : LEFT SINGLE QUOTATION MARK, 92 = U+2019 : RIGHT SINGLE QUOTATION MARK,
93 = U+201C : LEFT DOUBLE QUOTATION MARK, 94 = U+201D : RIGHT DOUBLE QUOTATION MARK
are the default quotation marks of the Microsoft Word product, so if you have data that comes from
Microsoft Office products you *need* a WE8MSWIN1252 database characterset.
Make sure you clients NLS_LANG is also correct:
Note 179133.1 The correct NLS_LANG in a Windows Environment

* all characters included in the P1 characterset are included in WE8MSWIN1252 so 1252 is
a *logical* superset of P1
* no codepoints have a different symbol in WE8MSWIN1252 than in P1 so
1252 is a *binary* superset of P1.

* up to 8i the *default* NLS_LANG of a windows (!) client installation was
WE8IOS8895P1, wich is in fact incorrect, the correct value is WE8MSWIN1252.

Note:179133.1 The correct NLS_LANG in a Windows Environment

This lead to a lot of WE8ISO8859P1 databases containing in fact WE8MSWIN1252
….

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=341676.1

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s