About interactions with non-ASCII databases

You must understand the encoding and date format that your database server and client use, and ensure that you configure Unica Campaign correctly for these settings.

When an application communicates with a database, several language-sensitive areas must be understood between them, including:

  • The format of date and time fields
  • The encoding of text in character-based fields
  • The sorting order expected in ORDER BY clauses of SQL SELECT statements

Unica Campaign communicates directly with the database client and the client communicates with the database. Each database varies in how it handles language-sensitive data.