Migration from Portuguese to English server - MySQL Error
Hi guys, I just migrated my PHP system (using MySQL db) from a Portugues server to GoDaddy and I am unable to save/execute certain areas which contain numerical values. In Portuguese we use commas instead of points and points instead of commas (R$1.200, instead of the US format of $1,200). The error number is 1366 (incorrect decimal value). Your help is much appreciated.
Hi, @smlang77. Thanks for being part of GoDaddy Community!
I'm not sure what the best way for you to go about this would be. In looking online, I came across this Stack Overflow post that seems to touch on what you want to do. It might be helpful. Of course, other Community members may have additional suggestions.
I hope you're able to get this solved! If so, please follow up with your solution so others can benefit from what you've found.
JesseW - GoDaddy | Community Manager | 24/7 support available at x.co/247support | Remember to choose a solution and give kudos.