I have CHAR columns in database in 500 tables. There are currently no
VARCHAR columns.
My C# application receives character data with trailing spaces from npgsql.
This makes application code complicated. Application must remove trailing
spaces from incoming data for C# string manipulation to work.
Also Tom Lane strongly recommends using VARCHAR always and never use CHAR
columns.
Is it reasonable do convert all CHAR columns in database to VARCHAR columns
in whole database.
Where to find such script ?
Shoult I make a loop over all columns and execute ALTER TABLE statements
in transaction making all constraints deferred?
I have also some triggers, indexes and sequences in database and execute
statements into database which contain a lot of operations with CHAR
columns.
Will database work OK after such conversion?
What things may be broken ?
Or is it better to hack npgsql code so that it removes trailing spaces
itself ?
Andrus.
