AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Everything Else
MySQL Column Width ...
 
Notifications
Clear all

Questions MySQL Column Width Bug

 
Everything Else
Last Post by busyfritz 5 years ago
1 Posts
1 Users
1 Reactions
1,999 Views
RSS
busyfritz
Posts: 16
 busyfritz
Topic starter
November 10, 2021 11:49 am
(@busyfritz)
Eminent Member
Joined: 6 years ago

We're having the issue described below with Acumatica and cannot find a solution. We have an open ticket and Acumatica support has been sporadically working on it for several weeks now but no answer. They can't reproduce it and so have done a screen share to look at it on my machine, but to no avail. Posting here in hopes that someone can help

We've tried a fresh install on other computers and get the same error.

Environment:
Acumatica 2021 R2
MySQL 8.0.26 Community on Windows Server 2019 Standard

When adjusting the column width of a GI, the following error message is thrown:

image

 

I have tried various combinations of charsets on the database to no avail. I have also tried different column types with the same result

Here is the database character setup:

image

 

The database:

image

 

The table:

image

 

 

This Stackoverflow article may shed some light:
https://stackoverflow.com/questions/37062643/incorrect-string-value-mysql-issue-when-inserting-utf8-text-into-a-latin1-col


Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 76 Online
  • 2,438 Members
Our newest member: Ralph Torres
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×