In Italian language we have accent words like àèéìòù
They are quite important because for instance “is” is spelled
whereas “and” is spelled
Accent are bad guys even today: if you copy them from MS-Word inside an Oracle sql script you can end up with different UTF-8 values.
Also the accent are likely to be destroyed if you past them in your html page without using the correct html entity (i.e. è )
Sometimes you need to export the data inserted with accent: an Oracle Virtual column can be an elegant solution….if you have at least Oracle 11g.
Also a magic update can fix some nasty problems….here the solution:
ALTER TABLE TEST_TABLE ADD( NAME_NORMALIZED generated
( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(
The compare pane will enable you to compare the databases.
But the default options will also use schema name to detect different object, so you will not get what you want in every scenario.
In 50% of my daily job, schema are different, so you must select the options below to fix it:
Select “Options” and then “Compare options”. Then de-select “Use schema property” like suggested below:
Push the “Sync new object”. Then push the “DLL Preview” button and inspect the generated database.
Bonus: by default the tool will not include tables to drop. Inspect the two pane ad check the table you want to drop in the left pane.
Refrain launching the script without proper testing. You are migrating your valuable data.