I don't remember if I have wrote about it. But anyway I think it is
worth to remember.
Once I had some problems with string that had \0 inside. I used that
string in the query like this:
UPDATE sometable SET somefield='something' WHERE otherfield='\0sometext'
and otherf1=123;
The effect was quite unusual. All the records was updated like there was
no condition at all. After this happend I added filters in all of my
programs to catch those nulls. But I think that it should be taken care
inside.
Mike
- --
******** MEMBER OF THE INTERNATIONAL PROGRAMMERS GUILD ********
WWW: http://www.lodz.pdi.net/~mimo tel: Int. Acc. Code + 48 42 148340
add: Michal Mosiewicz * Bugaj 66 m.54 * 95-200 Pabianice * POLAND
------------------------------
