# Type Handling

> Source: https://docs.synthesized.io/tdk/latest/user_guide/080_troubleshooting/type_handling/
> For the complete documentation index, see [llms.txt](https://docs.synthesized.io/llms.txt).

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

- [Custom Types (ENUMs, Composite)](https://docs.synthesized.io/tdk/latest/user_guide/080_troubleshooting/type_handling/custom_types)
- [Geometric Types](https://docs.synthesized.io/tdk/latest/user_guide/080_troubleshooting/type_handling/geometric_types)
- Arrays and JSON types

### Oracle

- [Auto-generated Types](https://docs.synthesized.io/tdk/latest/user_guide/080_troubleshooting/type_handling/autogenerated_types)
- LOB types (CLOB, BLOB)
- XMLType

### SQL Server

- NVARCHAR vs VARCHAR
- UNIQUEIDENTIFIER
- XML types

## See Also

- [Supported Databases](https://docs.synthesized.io/tdk/latest/user_guide/070_integrations/databases/)
- [Data Types](https://docs.synthesized.io/tdk/latest/user_guide/040_reference/data_types/)