1
Documentation / Re: Translating names and values for configuration objects with SQL Server
« on: March 09, 2021, 01:04:19 PM »
Hi Justin,
I created the database following https://www.ibm.com/support/pages/creating-remote-microsoft-sql-server-database-ibm%C2%AE-content-manager-ondemand.
There's no mention of the collation, so as the install worked for double byte with FileNet, I left it alone. The original collation was Latin1_General_CI_AS. That didn't work.
I created a new DB with SQL_Latin1_General_CP1_CI_AS. I found a reference (see PDF attachment https://www.ibm.com/support/pages/node/616131) that showed that as a selection on install. It doesn't work for me.
The documentation https://www.ibm.com/support/knowledgecenter/SSEPCD_10.5.0/com.ibm.ondemand.installmp.doc/dodnl005.htm doesn't provide absolute facts. It describes vague information and then more vague examples. It describes that if you had this value then some other thing would be required, but doesn't provide either guidance on where the value is stored, how it is changed or what the other thing that might be required actually is, or what the possible values are. Very obtuse, poorly constructed, incomplete and confusing documentation.
With SQL Server there is no 'code page' thing. There's a collation. There's no documentation I can find that specifies what the collation should be for any given OnDemand configuration. My SQL Server install doesn't support UTF-8, without me upgrading, which I really don't want to do, yet, but I don't know if it's using UTF-8 either. Latin characters are fine, double byte ones are not. How do you tell it to do something different? The documentation references ARS_ORIGINAL_CODEPAGE but wanders around from one release to another with possible indeterminate values. It looks like for 10.5 a value of 0 is required. There's no documentation that describes what value 0 means, or what other values are possible or what they do.
I've been down several rabbit holes already, rebuilding the DB, hacking columns to NVARCHAR, and without some absolute definition I'm just wasting my time.
There's no definition of what OnDemand is doing when it inserts data from the admin tool into the DB. How do you configure OnDemand to use a specific codepage? Do I need to? How does that map to any concrete value in SQLServer? It should be a trivial thing and it should be the same regardless of it being a remote SQL, so I'm hoping that someone that uses DBCS has some guidance on what the configuration values that work are.
Thanks,
David
I created the database following https://www.ibm.com/support/pages/creating-remote-microsoft-sql-server-database-ibm%C2%AE-content-manager-ondemand.
There's no mention of the collation, so as the install worked for double byte with FileNet, I left it alone. The original collation was Latin1_General_CI_AS. That didn't work.
I created a new DB with SQL_Latin1_General_CP1_CI_AS. I found a reference (see PDF attachment https://www.ibm.com/support/pages/node/616131) that showed that as a selection on install. It doesn't work for me.
The documentation https://www.ibm.com/support/knowledgecenter/SSEPCD_10.5.0/com.ibm.ondemand.installmp.doc/dodnl005.htm doesn't provide absolute facts. It describes vague information and then more vague examples. It describes that if you had this value then some other thing would be required, but doesn't provide either guidance on where the value is stored, how it is changed or what the other thing that might be required actually is, or what the possible values are. Very obtuse, poorly constructed, incomplete and confusing documentation.
With SQL Server there is no 'code page' thing. There's a collation. There's no documentation I can find that specifies what the collation should be for any given OnDemand configuration. My SQL Server install doesn't support UTF-8, without me upgrading, which I really don't want to do, yet, but I don't know if it's using UTF-8 either. Latin characters are fine, double byte ones are not. How do you tell it to do something different? The documentation references ARS_ORIGINAL_CODEPAGE but wanders around from one release to another with possible indeterminate values. It looks like for 10.5 a value of 0 is required. There's no documentation that describes what value 0 means, or what other values are possible or what they do.
I've been down several rabbit holes already, rebuilding the DB, hacking columns to NVARCHAR, and without some absolute definition I'm just wasting my time.
There's no definition of what OnDemand is doing when it inserts data from the admin tool into the DB. How do you configure OnDemand to use a specific codepage? Do I need to? How does that map to any concrete value in SQLServer? It should be a trivial thing and it should be the same regardless of it being a remote SQL, so I'm hoping that someone that uses DBCS has some guidance on what the configuration values that work are.
Thanks,
David