Reported lengths of char fields - psqlODBC
Bob Brodd <[email protected]> Tue, 5 Feb 2019 17:23:45 -0500
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <CAHbe0hH-degRJXD2tmNCoA1RBrVJGLKj_U7udB04uJYGx1-mbQ@mail.gmail.com> |
Environment: Linux Mint 18.3 x64 (base on Ubuntu 16.04 package base) Postgresql v 9.5.14 unixODBC v2.3.1-4.1 psqlODBC v1:09.03.0300-1 I created a simple table containing one column of type character (n). When I ask for the width of the column via (ODBC)SQLColAttribute function, it answers (n*6) , so if defined as character(1) the call reports length 6, character(2) reports 12, character(4) reports 24, etc. I see the same kind of results when using a varchar(n) field (character varying (2), etc ) as well . Is this expected, or am I doing something wrong? Thanks, Bob