Problems with ALTER TABLE

[pak attack]

Hi! I have a problem with an instruction type. Oracle use:

ALTER TABLE <NAME_OF_TABLE> ADD CONSTRAINT <CONSTRAINT_NAME> CHECK ...

I red that MySQL 4.1 is not capable of make that instruction (CHECK).
When I try to make the instruction the program says: "QUERRY OK!"
But later, when I try to insert the data, the program does not respect the restriction required. My question is:
1) Exist any older version of MySQL that support the "CHECK"?
If that is the case, I would like to know the version and if these version support replication and connector/J.

2)What other alternative I can use instead of CHECK? Can I use TRIGGERS?

Thanks for the attention. These can help me to make a good project to complete my career.