(NAV 2009 Classic.)
We are having issues with a database that is going to be used from several countries around the globe – both Europe and Asia. Each country has their own Terminal Server set in local non-unicode codepage. Each company is only used in one country, but we are unable to store local chars unless the collation of the database match the language of the country.
We are therefore considering batch job that changes the collation of all Text fields in the tables belonging to each company. (we are also considering Code fields, but we don’t think it will be necessary) We foresee a few issues , but nothing serious:
Not handling shared tables
Might cause issues if we access the SQL tables directly for JOINs or replication etc.
We need to run the batch job each time a FOB is imported.
Does not allow object names or fields names to be localized
Has anyone tried this approach or have any objections or recommendation about it?