Hi,
I'm trying to set up some translations of folder names, field names and field values on a 10.5 system with Remote SQL Server and I'm having issues with ?? values being stored in the database and displayed in the admin UI after entering valid names in non-latin languages (eg Arabic, Japanese, Chinese, Korean).
The documentation is verbose yet doesn't explain what the system is doing. As it's a remote SQL server, the documentation is sparse in describing the installation and any dependencies. The database server is an existing one (SQL Server 2016) that works fine with other products (eg IBM FileNet) in correctly storing and retrieving double byte characters. The database system cannot be changed easily, so before I do anything dramatic I'd like to understand what the system is doing, what else I may have missed, and if anyone else is already using these translation features in the administration tool.
I've tried different database collations. One document I found showed SQL_Latin1_General_CP1_CI_AS being used. I can't find any documentation that describes what the collation for SQL Server should be. The other databases on the same server that work with DBCS are using Latin1_General_CI_AS. That same collation also doesn't work for OnDemand. The same behaviour occurs, the data can be entered and displays correctly, when it's saved to the DB it's shown as ??, when it's retrieved in the UI, it's a series of ??. My system is in Sydney, so the base locale info is en-au. All of the latin languages (eg spanish, french, german) work.
I've discussed with a colleague the same actions on an OnDemand with DB2. They work fine. It seems to be some additional or different settings needed for SQL Server.
With all that background:
1. Has anyone got an English based OnDemand system using SQL Server that has any double byte character translations for Cabinet, Folder, Hold, Field or Field Value entries that persists the data correctly? I'm using 10.5 but any indication on any version will give me more of an idea what the issue might be.
2. There are lots of pieces of documentation around code pages but no sensible definition of where and how they're used, exactly. There's also lots of references to configuration files that don't exist anymore in the documentation. Without some solid documentation I'm not ready to hack too much more. Is this where I'm going wrong?
I think it's code page related, but the doco is truly awful. There's no complete discussion that covers my corner case and I'm not ready to waste more time guessing.
Any guidance is greatly appreciated.
David