SET field = CONCAT(field, 'text')

[Anon]

I have this line:
UPDATE table SET field = CONCAT(field, ', $value') WHERE id=$row[0]

It works perfectly well in a server with a MySQL db, in all cases.
But in another server, with another MySQL db, it only works when 'field' is not ''.
According to MySQL documentation, CONCAT() works perfectly well unless a NULL argument is given. So, I guess some MySQL databases consider '' as NULL and other don't.
How can I configure the 'bad' db in order to make it consider '' as not NULL?

[bastien]

check the table set up...it might be that the same field on the other machine is set not to accept null values..change that and you should be okay...

hth