>>Has anyone already assembled a table mapping column types to witango >>DataTypes? >> >>Here's a start >> >>For MySQL >>vcha --> VARCHAR, ENUM, ... >>lbin --> MEDIUMBLOB, LONGBLOB >>text --> CHAR, >>long --> INT(10), INT(11)
FWIW, I have the following map for PostgreSQL via ODBC: PG Type Witango Code Notes ----------- ------------ ------------------------------- integer long bigint vcha Wrong type! smallint shor decimal deci numeric deci real floa double dobl serial long bigserial vcha Wrong type! text lcha Easily confused with char/text vchar vcha char text Easily confused with text/lcha bytea vbin boolean text timestamptz tims No time zone distinction timestamp tims interval vcha Could be wrong type date date time time timetz vcha Could be wrong type -- Jeff Bohmer VisionLink, Inc. ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
