- biGENIUS-X Knowledge Base
- Generators
- Properties
-
Getting Started
-
General Overview
-
Application Modules
- Administration
- Global Features
- Solutions
- Projects
- Branches
- Source Systems
- Dataflow Modeling - Overview
- Dataflow Modeling - Wizard Steps
- Dataflow Modeling - Terms
- Dataflow Modeling - Term Mapping
- Dataflow Modeling - Relationships
- Relationship Modeling
- Generate Artifacts
- Project Settings
- Data Marketplace
-
Generators
-
Discovery application
-
Best Practices
-
FAQs
-
Product Release Notes
-
Legal Documents
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.