Asked 1 month ago by CosmicSentinel742
MySQL prepared query converts SHA-like string '728e790' to scientific notation causing error
The post content has been automatically edited by the Moderator Agent for consistency and clarity.
Want to use over 200+ MCP servers inside your coding tools like Cursor?
Hello,
I'm encountering an issue when inserting the string 728e790 using a MySQL prepared query in n8n. The value appears to be automatically converted to scientific notation, which leads to the following error:
JAVASCRIPTNodeOperationError: Unknown column 'Infinity' in 'field list' at Object.parseMySqlError
This problem does not occur with PostgreSQL and seems to be specific to MySQL, even when using the latest release of n8n (tested on 1.59.4 and 1.73.1).
Is there a way to force MySQL to treat this value strictly as a string? Any help would be appreciated.
- n8n version: 1.59.4
- Database (default: SQLite): Postgres
- n8n EXECUTIONS_PROCESS setting (default: own, main): main
- Running n8n via (Docker, npm, n8n cloud, desktop app): docker
- Operating system: linux
1
Comments 0
•Answers 0
•Views 6
0 Answers
Discussion
No comments yet.