Title: Message
Hi All,
 
We use Orion CMP features with MySQL. We had problems with boolean and char fields.
I used P6Spy (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/

Reply via email to