Roozbeh Ghaffari wrote: > Hi All, > > > > We use Orion CMP features with MySQL. We had problems with boolean and > char fields. > > I used P6Spy (www.provision6.com <http://www.provision6.com>) to see > SQL commands generated by Orion. > > Orion says: > > update table_name set boolean_field = 'true' > > but MySQL expects > > update table_name set boolean_field = '1' > > > > How can I ask Orion to generate the expected SQL? > > > > But in case of character field we have a bigger problem. > > I try to set a character field to 'F' or 'M' > > Orion says: > > update table_name set char_field = 0 > > !!! > > I don't understand what is happening! > > > > Thank you in advance, > > Roozbeh/ >
Sounds like You're missing $ORION_HOME/config/database-schemas/mysql.xml michael -- Dipl.-Math. (fh) Michael Simons UNIOPT AG // unique logistic optimization Maximilianstr. 29; D-93047 Regensburg phone: ++49(0)941/59578-0 http://www.uniopt.net/
