Post date: Jan 13, 2016 4:49:32 AM
UTF-8 Database is required to support Internationalization. So, we must request / insist DBA to provide UTF-8 Database for Triniti Instance at the time of installation process. The character set can't be changed to UTF-8 after deployment. Other character sets like WE8ISO8859P1 might not support all languages.
We encountered a situation in SunPower, where Triniti database is having WE8ISO8859P1 Character set, which is not allowing all types of special characters, for example: "SUNPOWER MÜHENDISLIK INSAAT ENERJI ÜRETIM" (Turkish data) to insert into database. Additional efforts are required to convert character set from Western Europen to UTF, even then there is a possibility for data loss.