it's not that "query ignores characters", it has more to do with how string-to-uuid conversion works.
to understand how it works, create a UUID field, create a record, assign a value. e.g. CREATE RECORD([Table_1]) [Table_1]Field_2:="www" you will notice that Field_2 which is a UUID, evaluates as 77777720202020202020202020202020 in the debugger. another example [Table_1]Field_2:="abcd" 61626364202020202020202020202020 but [Table_1]Field_2:="abcdabcdabcdabcdabcdabcdabcdabcd" ABCDABCDABCDABCDABCDABCDABCDABCD so if the string isn't a 32-digit hex, it is first transformed to look like one (UTF-8 character code, padding by spaces). then it is evaluates as integer (UUID). then it is converted back to string for display (hence the uppercase). ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
