Re: Weird behavior on varchar fields

2004-08-17 Thread Philippe Poelvoorde
Oropeza Querejeta, Alejandro wrote: Hi, I have one table that is presenting strange behaviour, we set the varchar field for not allow nulls so, on 5% of the records the application is inserting blanks but when we select the value and we set the condition ="" it returns the same as " " and "

Weird behavior on varchar fields

2004-08-16 Thread Oropeza Querejeta, Alejandro
Hi, I have one table that is presenting strange behaviour, we set the varchar field for not allow nulls so, on 5% of the records the application is inserting blanks but when we select the value and we set the condition ="" it returns the same as " " and " ". Even, we tried to set the field