30
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

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

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

Category: System

M

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