Hello all - I have converted a database from v2004 to v12, and Unicode is ON.
Conversion4Dv11SQL_R9.pdf, page 69, says: In Unicode Mode, if you want to check if a string does not contain any characters, including ignorable ones, you need to use the following test: If (Length(vText)=0) Instead of If (vText=""). I don't see that advice repeated anywhere else in v11 or v12 docs, but I may have missed it. To find empty strings, both v11 and v12 Language docs recommend: QUERY([People];[People]Company="") In previous versions, I would assume that "an empty string" was the same thing as "a string that does not contain any characters", but in this context I'm not sure.... QUESTION: In versions 12+, in unicode mode, if the field contains only routine Western characters, is it okay to continue to use QUERY([Table];[Table]Field="") and only if the field may contain nonWestern characters, use QUERY SELECTION BY FORMULA([Table];Length([Table]Field)=0) ??? Thank you - Janie Marlow ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************