Posts by John Calistro • 81 points

• 0

  votes

  1

  answer

  374

  views

  A: 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…

  sql sql-server asp

  answered 9 years, 10 months ago John Calistro 81

• 3

  votes

  1

  answer

  1733

  views

  A: 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…

  php mysql character-encoding

  answered 9 years, 10 months ago John Calistro 81

• 2

  votes

  1

  answer

  12979

  views

  A: 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…

  mysql mysql-workbench sql-update

  answered 9 years, 10 months ago John Calistro 81