# sql: Scan error on column index 1: converting driver.Value type []uint8 ("123") to a int: invalid syntax

- **ID:** `go/database-sql-rows-scan-type-error`
- **Domain:** go
- **Category:** data_error
- **Verification:** ai_generated
- **Fix Rate:** 80%

## Root Cause

The database driver returned a type that cannot be directly converted to the destination Go type in Scan.

## Version Compatibility

| Version | Status | Introduced | Deprecated |
|---------|--------|------------|------------|
| 1.20 | active | — | — |

## Workarounds

1. **** (90% success)
   ```
   Use sql.NullInt64 or specify the correct type in the SELECT query, e.g., CAST(column AS SIGNED).
   ```

## Dead Ends

- **** — May lose numeric precision or cause type mismatches in downstream code. (50% fail)
- **** — Clunky and error-prone; may not handle all types correctly. (60% fail)