[UrbanSim-Users] MySql configuration

Hi,

In the installation Instructions for MySql in order to use with Urbansim
application is the following :
http://www.urbansim.org/docs/installation/mysqlinstall.4.1.html

Are all these settings mandatory, especially for these points :

1) Non-transactionnal database
When prompted for the type of database usage, please choose
'Non-transactional Database Only' to configure the server to be compatible
with UrbanSim. (The MyISAM format stores each table as a set of three files:
a .frm, a .MYD, and a .MYI file. The InnoDB format does not use these
files.) Press the 'Next' button.

Is it possible to set the InnoDB transactionnal database ?
Perhaps not, because not all data produced by Urbansim/Python programs are
not explicitly commited to the database. For sample where launch a
run_estimation.py the table land_price_model_coefficients was created but
empty, in order to solve the problem we have add a "commit" statement at the
end of the script.

2) Character Set
On the following screen, make sure the 'Standard Character Set' option is
selected and proceed by pressing the 'Next' button.
(It makes the Latin1 the default character set)

Can we use the UTF8 character set ? In our experiences for loading new data
in MySql database from external files (LOAD DATA instruction) it fails using
the Latin1 character and table successfully loaded if the table set with
UTF8 character set.

In MySql, is it possible (by a setting) to force the Decimal separator (ie:
International = "." French = ",") to match the file data to load in MySql ?

In Windows MySql use the regional setting to determine the Decimal separator
and an error appears if it not match the file data.

Thanks in advance.
Philippe.
Received on Wed Sep 12 2007 - 10:56:59 PDT