CODEWITHSUNDEEP
oracle-databaseoracle11g
ibaneight
ibaneight

Reputation: 1445

Oracle WE8MSWIN1252 characterset in unix based system

I'm searching to migrate an ORACLE 11 database based in Windows system and with WE8MSWIN1252 characterset to an ORACLE 12 based in Unix system.

The WE8MSWIN1252 character set is an option in a Unix based system or is a Windows exclusive Character set?

Thanks.

Upvotes: 0

Views: 2730

Answers (2)

Dmitry Demin
Dmitry Demin

Reputation: 2113

On the oracle server, you can set any encoding that the DBMS supports. In my practice, I used the cl8mswin1251 character set on the UNIX Solaris, Linux server. If the character set database and the client is the same, then no conversion is required.

Upvotes: 0

Wernfried Domscheit
Wernfried Domscheit

Reputation: 59523

I think you can use WE8MSWIN1252 also on Unix systems, at least at Choosing a Character Set there is nothing mentioned about that. The only restriction seems to be:

ASCII-based character sets are supported only on ASCII-based platforms. Similarly, you can use an EBCDIC-based character set only on EBCDIC-based platforms.

However, you should consider to migrate to Unicode AL32UTF8, see Character Set Migration

Upvotes: 1

Related Questions