Numbers returned as strings

Thats deliberate. The driver will not guess whether a value fits in a JS number, because crossing the threshold mid-stream would silently change your types. Supply a custom cast function to convert them how you like.

1. Add a custom cast function in your connection config. See the README's custom type casting section for the hook.
2. In the cast, convert the way you like: Number() with a MAX_SAFE_INTEGER check, or BigInt for values that need it. Expected: the columns come back as numbers (or BigInt) instead of strings.

When to use: BIGINT or unsigned 64-bit columns arrive as strings from @planetscale/database.

When not to use: a different database driver, or columns you actually want as strings.

Compatibility: @planetscale/database (Node.js). Reported in planetscale/database-js#175.

Variants:

• "planetscale bigint string"
• "planetscale numbers returned as strings nodejs"
• "planetscale custom type casting"

Root cause: deliberate driver behavior. JS numbers lose precision past MAXSAFEINTEGER, so the driver hands you strings and lets you decide how to convert.

Edge cases: values above Number.MAXSAFEINTEGER need BigInt. Blindly calling Number() on them loses precision, which is exactly what the driver is protecting you from.

In gh:planetscale/database-js#175, the issue was: In the following test suite, when using PlanetScaleDialect and receiving more than one row, what I expected to be numbers is parsed as strings instead: ```ts import { Kysely, MysqlDialect } from "kysely"; import { PlanetScaleDialect } from "kysely-planetscale"; import { createPool } from "mysql2"; import { strict as assert } from "node:assert"; import { describe, test } from "node:test"; import { fetch } from "undici";. The verified answer: If @planetscale/database returns BIGINT or unsigned 64-bit columns as strings, that is deliberate: the driver will not guess whether a value fits in a JS number, since crossing the threshold mid-stream would silently change your types. Supply a custom cast function (see the README's custom type casting section) to convert them how you like, for example Number() with a MAXSAFEINTEGER check, or BigInt.. Issue URL: https://github.com/planetscale/database-js/issues/175