Friday, October 3, 2014

Difference between WE8ISO8859P1 and WE8MSWIN1252 characterset

The lists of characters along with their code points used in oracle database character set WE8ISO8859P1 is defined in the http://msdn.microsoft.com/en-us/goglobal/cc305167.aspx.

And the lists of characters along with their code points used in oracle database character set WE8MSWIN1252 is defined in the http://msdn.microsoft.com/en-us/goglobal/cc305145.aspx

  • If we look for the characters and code points for both character sets then we will find that every characters defined under WE8ISO8859P1 exists in character set WE8MSWIN1252 plus WE8MSWIN1252 contains some additions characters. So we can say WE8MSWIN1252 is logical super set of WE8ISO8859P1.
  • If we look further details, we see total 27 code points are not existing in P1 that are filled in / used in WE8MSWIN1252.
Also, no code points have a different symbol in WE8MSWIN1252 than in WE8ISO8859P1 soWE8MSWIN1252 is a binary super set of WE8ISO8859P1.

For more details 
http://arjudba.blogspot.com/2009/03/difference-between-we8iso8859p1-and.html