Conversion from ANSI to Unicode requires changing datatypes on text, varchar and char columns in the database.
Running a script on the database is required to affect this change.
Verification:
1. Verify the Database:
Launch the database upgrade wizard and connect to the database
Once connected the Wizard will confirm in database details whether the database is ANSI or Unicode.
Exit without executing the upgrade
OR
Run the following query and to verify no results: Char as not used in data model:
select isc.table_schema, isc.table_name, isc.column_name, isc.data_type, isc.is_nullable, isc.character_maximum_length from information_schema.columns isc inner join information_schema.tables ist on isc.table_schema = ist.table_schema and isc.table_name = ist.table_name where exists ( select * from oq.omsystem syst where syst.dbdomain = isc.table_schema ) and isc.data_type in ( 'text', 'varchar', 'char' ) and ist.table_type = 'BASE TABLE'
-- should not find char as not used in data model
OR
Run the test Instance utility in APM Configuration Application:
AND
2. Run the product
Log in and Visit views and open objects, check them out and do edits