26
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
Under Review
Ideas Administrator

Jodi Christiansen (administrator)

Hello Marc, 

Thank you for your suggestion. We will consider this for a future release.

Jodi Christiansen
PM, Microsoft

Comments

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