30
M

Replace CHAR Data Type with VARCHAR

Marc K on 3/15/2018 4:05:14 PM
Dynamics GP stores text fields using the CHAR data type. This pads the value with spaces. CHAR wastes space and introduces problems with custom reporting. We have to add RTRIM to custom queries to get rid of the extra spaces.

Please consider converting to using VARCHAR for text fields.
Category: System
STATUS DETAILS
Declined
Ideas Administrator

Jodi Christiansen (administrator) on 9/20/2022 7:54:18 PM

At this time there are no scheduled plans for this feature.

Thanks

 

 

Terry Heley | Sr. Escalation Engineer | Microsoft Dynamics

701-492-6376 (o) | 701-412-5619 (m) | theley@microsoft.com

MSFT_logo