Re: Inserting an empty string inserts a space

I don't know the particulars about how the data is handled internally by informix. Black box techniques reveal that informix doesn't seem to distinguish between an empty string, a string with a single space character, or strings with multiple space characters. Try to query from your table where url = ''; I think it will find your row even though it displays it as a single space. ======================================================================== Tauren Mills wrote: > UPDATE product_info SET prod_id = 1, prod_type_info_id = 1,> short_description = 'Test', url = '', sort_order = 1 WHERE > prod_info_id=1; > > The field "url" should be set to an empty string, but every time this > statement is executed, the "url" field has a single space in it: ' '.