MySQL datatypes ranges (out of range) | Railway | Page 1

snow rivet Feb 9, 2026, 10:27 PM

#

Hi, I am getting an error for database when trying insert time unix value to field (INTEGER).

(pymysql.err.DataError) (1264, "Out of range value for column 'ts' at row 1")

i.e. 1770672600000, log shows out-of range. I was not able to find any docs for datatypes within Railway DB...I am not well informed what ranges are allowed for available datatypes. Can anyone tell me and reccomend how to store this unix time value in miliseconds?

latent kestrelBOT Feb 9, 2026, 10:27 PM

#

Is this about a specific service? Linking one helps us understand your setup.

lethal cedar Feb 9, 2026, 10:28 PM

#

Is this error from the Railway UI?

snow rivet Feb 9, 2026, 10:28 PM

#

From deploy log.

{"message":"(fn) db_insert_router: Data routing to database failed - (pymysql.err.DataError) (1264, "Out of range value for column 'ts' at row 1")","attributes":{"level":"info"},"timestamp":"2026-02-09T22:00:05.207770277Z"}

#

I cannot insert this value...there is not option to select bigint in datatypes options.

snow rivet Feb 9, 2026, 11:04 PM

#

lethal cedar Is this error from the Railway UI?

I am currently saving unix in seconds as it is equal to int capacity. I would still appreciate some source docs for applicable mysql datatype ranges for listed options when setting DB in Railway. Does exist any source?

lethal cedar Feb 9, 2026, 11:08 PM

#

It's just standard MySQL, nothing at all Railway-specific, so I will open this thread up to the broader community so they can assist.

#MySQL datatypes ranges (out of range)