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

Comments

M

M

RE: Replace CHAR Data Type with VARCHAR

Mitchell Marklow on 8/4/2022 8:34:49 PM

All hosted platforms paying for disk space shed a tear when they learned this was declined. Your space overlords command you.

Category: System

M

M

RE: Replace CHAR Data Type with VARCHAR

Mariano Gomez on 10/1/2018 7:41:15 PM

I would much prefer the ability to store text data as NVARCHAR to support Unicode and multi-lingual characters. Is it possible to also extend Dexterity support for Unicode for both String and Text controls?

Category: System