UTF-8 & SQL2005
I am preparing to install Enterprise XI 3.0 and setup the CMS database. The documentation indicates that it is critical to use the UTF-8 characterset however he is leary after learning that there might be some support issues with SQL2005.
He has posed the following question: At the database level (not Sql server or O/S layer), what is the specific collation to which the EnterpriseXi databases need to be set?
Does anyone have any knowledge of this situation?