Posts by John Calistro • 81 points
3 posts
-
0
votes1
answer374
viewsA: Error using sql Insert(SQL Server) command, via classic ASP
The problem is here ",LEFT('" & this.item("texto_comprovante") & "', 255) " left comma makes mysql understand that there is one more parameter, to solve, use the function before calling the…
-
3
votes1
answer1733
viewsA: Emoji insertion problems in mysql
ATTENTION: THIS ANSWER IS NOT MY OWN, WAS TRANSLATED FROM https://stackoverflow.com/questions/7814293/how-to-insert-utf-8-mb4-characteremoji-in-ios5-in-mysql TO ASSIST ME IF I DO NOT HAVE THE…
-
2
votes1
answer12979
viewsA: Error Code: 1406. Data Too long for column 'txtContability' at Row 1
Changing the field to longtext should solve the problem, this error is triggered when the amount of characters is greater than the field’s storage, so the excess characters are truncated. The limit…