So I am querying an SQL Server DB which has many CHAR fields with ANSI Padding Status ON. This means that for a CHAR(10) field, the value may be "123" but I'm instead receiving "123......." (whitespace) in the result.
Is there a best practice method to handle this?
Apply python's strip before you save it.
Or add a method to the model which strips whitespace from the property when called. You could even override the default getter method.