arrow-odbc icon indicating copy to clipboard operation
arrow-odbc copied to clipboard

fix: Trim whitespace from CHAR types

Open peasee opened this issue 7 months ago • 1 comments

🗣 Description

Trims whitespace from the end of CHAR datatypes when converting records to RecordBatch

This follows existing behavior from PostgreSQL:

Trailing spaces are removed when converting a character value to one of the other string types.

MySQL:

When CHAR values are retrieved, trailing spaces are removed unless the PAD_CHAR_TO_FULL_LENGTH SQL mode is enabled.

And arrow conversion in datafusion-table-providers

🔨 Related Issues

peasee avatar Jul 15 '24 02:07 peasee