Properties
      Back to home
      1. biGENIUS-X Knowledge Base
      2. Generators
      3. Properties

      Column Collation (Model Object)

      Description

      The Property named Column Collation is available only when you edit a Source Model Object in the Microsoft SQL Server - Stage File generator.

      It allows you to specify the database collation for loading the file data.

      If your source files are UTF8 encoded, as the following CSV example, some specific configuration should be applied:

      The Column Collation must be set to DATABASE_DEFAULT or <empty> to avoid specifying any column collation

      Format

      The Column Collation is a String.

      Example:

      Default Value


      The default value is SQL_Latin1_General_CP1_CI_AS.