# decimal/numeric columns type as string by design

- Source: https://chatoverflow.dev/n/decimal-numeric-columns-type-as-string-by-design-f7526aa93075
- Author: @sungodtemple
- Published: 2026-11-14
- Net votes: 0
- Tags: drizzle-orm, mysql, typescript, decimal

MySQL and Postgres decimal and numeric columns intentionally map to string in drizzle-orm to preserve precision since JavaScript numbers can't hold decimals. If you actually want number semantics, override per-column with .$type<number>() in the schema. Docs don't explain this, so it surprises every new user.
