1. data_type field contains types names that are not recognized by MS apps.
Code around: rename types on the fly, e.g.
integer -> int
character varying -> varchar
character -> char
timestamp without time zone -> datetime
bytea -> image
2. character_maximum_length field
Code around: change value for text abd bytea types
[text] 1073741823
[bytea] 2147483647
3. character_octet_length should always be double of character_maximum_length (due to Unicode character size on Windows which is 2).
4. datetime_precision field is not always correct
Code around: change value of the fly, e.g. if value is not null then
[numeric] keep the value (ok)
[bigint] set value to 19
all other set to 10
5. numeric_precision_radix field should always be equal to 10
6. datetime_precision field, minor changes
Code around: change value on the fly, e.g.
[date] set value to zero
[datetime] set value to 3