Database server is deployed first of all in Web applications. The installation files MySQL
can be get, for example, from www.mysql.com
Work with MySql database
- If the string type values are being stored into the database using the PmDatabase
object, it is necessary to to use unicode coding ucs2 or utf8 for the string character pack in MySQL and for the column strings data types.
- In the MySQL
ODBC driver the TIME
data type of the MySQL
databaze table column is not supported sufficiently (actualized 4.2007
If the 3.51.12 version driver is used, then, for example, while reading the data from MySQL databaze table using the attribute FieldValues the values are not readable at all or incorrect reading occurs.
Using the 3.51.14 version driver gives better results. The time reading is ok, but when stored in PROMOTIC the DATE information is also included (13:28:33 is stored in MySQL, but the ODBC driver in PROMOTIC reads for example 2007.04.28 13:28:33).
The database can be filled:
- by the PmDatabase
(obsolete) object via named ODBC
For next descriptions to the MySQL