LMSouq
database Open

Best data type to store money values in MySQL

MO
Mohammad Saberi
1 month ago
3 views
Problem Description
I want to store many records in a MySQL database. All of them contains money values. But I don't know how many digits will be inserted for each one. Which data type do I have to use for this purpose? *VARCHAR* or *INT* (or other numeric data types)?

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base