SQLServer Database-Generated API returns CHAR(36) with blank spaces

[leo-viana]

Goal

Track down what is causing the blank spaces on responses with id and fix them.

Description

When building any response that contains a table column of type CHAR(36) of a sqlserver database, the code seems to be retrieving the length of the type of the table column instead of the length of the value itself, rendering responses like the below:

Steps to Reproduce

• Create a SQLServer database that contains a table column of the type CHAR(36)
• Insert some data on the table with the type mentioned above
• Use the GET route of the table to retrieve the inserted data

[leo-viana]

Closing this because the database is probably filling the missing characters with empty spaces to enforce the CHAR(36) data type.