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 Type Mappings for supported types * 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