Configuring for multiple locales on SQL Server

About this task

Log in to Unica and configure the encoding properties listed in the following table. Set the values for the properties as specified here.

Property

Value

Campaign > partitions > partition[n] > dataSources > [data_source_name] > StringEncoding

WIDEUTF-8

Campaign > partitions > partition[n] > server > encoding > stringEncoding

UTF-8

Campaign > unicaACListener > logStringEncoding

UTF-8

Campaign > unicaACListener >systemStringEncoding

UTF-8. If necessary, you can set more than one encoding, separated by commas, but keep UTF-8 first in the series. For example: for example, UTF-8,ISO-8859-1,CP950.

Campaign > partitions > partition[n] > dataSources > [data_source_name] > ODBCunicode

UCS-2

For the configuration properties that specify date and time formats, accept the default values.