![]() Windows-1252 has several characters, punctuation, arithmetic and business symbols assigned to these code points. I need to have a varchar2 column, which contains Spanish character, converted to ISO-8859-1 from the sqlplus output. ISO-8859-1 assigns several control codes in this range. I have the server 11g with the NLSCHARACTERSET with A元2UTF8. "ISO-8859-1 (also called Latin-1) is identical to Windows-1252 (also called CP1252) except for the code points 128-159 (0x80-0x9F). So you see the shortnames but no Latin1 but CP1252 which is almost identical. Items marked with (*) represent the locale's original default You cant make the conversion of ISO 8859-1 to UTF - 8 in place because the UTF-8 version will be usually longer time (unless you convert a pure ASCII file. ![]() In namespace %SYS you have a utility NLS that shows your installed conversion table and its short names.
0 Comments
Leave a Reply. |