Type Handling

Troubleshoot issues related to data type handling, conversion, and compatibility.

Overview

This section covers:

  • Custom type handling

  • Auto-generated type issues

  • Geometric and spatial types

  • Type conversion problems

Common Type Issues

Unsupported Types

Symptom: "Unsupported data type" errors.

Solution:

  • Check the supported data types for your database

  • Use custom transformations for unsupported types

  • Consider type conversion before processing

Type Conversion Errors

Symptom: Data loss or errors during type conversion.

Solution:

  • Verify source and target database type compatibility

  • Check for precision/scale differences in numeric types

  • Review string length limits

Database-Specific Types

PostgreSQL

Oracle

SQL Server

  • NVARCHAR vs VARCHAR

  • UNIQUEIDENTIFIER

  • XML types

See Also