AnsweredAssumed Answered

change default value of a string from '' to NULL

Question asked by gianluca poli on Dec 23, 2014
Latest reply on Dec 24, 2014 by Muhammad Shaji Uddin
I am trying to create a unique field using a logic_hook, i can make the field UNIQUE in mySQL (that allows multiple NULL values) while Sugar sets the default value to '' (emplty string) which is of course a duplicated value!

How can i change the default value from '' to NULL so that multiple NULL values will be accepted by mySQL???

Outcomes