[mapserver-users] MySQL field-types to Dbase field-types
Azimuth, E. Perik
perik at azimuth.nl
Wed Mar 6 08:58:21 PST 2002
Hi All,
little offtopic maybe but has anyone tried to translate the table
field-types of MySQL to the table of a Dbase file using PHP?
Currently i am working on a function which translates a MySQL table to a
shapefile based on the index of the MySQL-fields where X and Y (lat / lon)
are situated.
All is set up and running ok, but it's now only based on a table with
doubles and strings.
These table-fields is a much longer list for a MySQL table then for a Dbase
table.
So in principle i need to pass:
- field-name
- field-type
- field-len
of a MySQL database to an array which defines the newly created database
using PHP.
So far i gathered the following MySQL field-types:
TINYINT
SMALLINT
INTEGER
MEDIUMINT
BIGINT
DECIMAL or NUMERIC
FLOAT
DOUBLE or REAL
TIMESTAMP
DATE
TIME
DATETIME
YEAR
String (<-- CHAR or VARCHAR)
BLOB or TEXT (use max_length to determine the maximum length)
SET
ENUM
NULL-type
For the dbase file the field-types are:
N (numeric)
C (character)
D (date)
L (logical)
M (memo).
Any help regarding this is greatly appreciated,
Erwin
More information about the MapServer-users
mailing list