Migrating to oracle forms12c from oracle forms6i
we have an application developed using forms 6i and reports 6i with a lot of fmb's and rdf's runs over oracle 11g r2 ,
the character set of the database is we8mswin1252, the db contains arabic data, the arabic data entered and retrieved successfully from the users which all have windows machines with NLS language = AMERICAN_AMERICA.WE8ISO8859P1
we faced a problem when take the step to migrate to oracle forms 12c all arabic data appeared like ???????????
after research a lot about the subject , we decided to change the characterset of the database to AR8MSWIN1256 which is the correct characterset of arabic.