value in db cant be found



  • action: select records by criteria
    filter: SomeField contains/equals this string/expression "42×342" wont find it.

    i saved this as string in db. now i cant find it as string nor as expression. not as equals and not as contains.

    btw this happens with similar strings 342x23 too

    for now i can remove them from db..but i cant find them with this script.. so i have to get their ID to remove them

    anyway just reporting this as bug

    it must have something to do with special chars:
    [180281272] [17:20:39] Thread #1 : Skipped and removed because can't find: follow—your–dreams.
    [180281272] [17:20:41] Thread #1 : Skipped and removed because can't find: 421×42.
    [180281272] [17:20:43] Thread #1 : Skipped and removed because can't find: forever–dopeless.
    [180281272] [17:20:45] Thread #1 : Skipped and removed because can't find: 1–nfinity.
    [180281272] [17:20:47] Thread #1 : Skipped and removed because can't find: 423×42.
    [180281272] [17:20:49] Thread #1 : Skipped and removed because can't find: fragmentary–girl.
    [180281272] [17:20:51] Thread #1 : Skipped and removed because can't find: 402×42.
    [180281272] [17:20:53] Thread #1 : Skipped and removed because can't find: 472×42.
    [180281272] [17:20:55] Thread #1 : Skipped and removed because can't find: fragic–magic.
    [180281272] [17:20:58] Thread #1 : Skipped and removed because can't find: forever–devoted.
    [180281272] [17:20:59] Thread #1 : Skipped and removed because can't find: 42×452.
    [180281272] [17:21:02] Thread #1 : Skipped and removed because can't find: floral–vintage.

    here the hyphen is not normal and in other lines X is not typical X.
    i was able to store it but not perform actions on it.

    nvm my bad ignore this post



  • @yourfriendkarol said in value in db cant be found:

    action: select records by criteria
    filter: SomeField contains/equals this string/expression "42×342" wont find it.

    i saved this as string in db. now i cant find it as string nor as expression. not as equals and not as contains.

    btw this happens with similar strings 342x23 too

    for now i can remove them from db..but i cant find them with this script.. so i have to get their ID to remove them

    anyway just reporting this as bug

    it must have something to do with special chars:
    [180281272] [17:20:39] Thread #1 : Skipped and removed because can't find: follow—your–dreams.
    [180281272] [17:20:41] Thread #1 : Skipped and removed because can't find: 421×42.
    [180281272] [17:20:43] Thread #1 : Skipped and removed because can't find: forever–dopeless.
    [180281272] [17:20:45] Thread #1 : Skipped and removed because can't find: 1–nfinity.
    [180281272] [17:20:47] Thread #1 : Skipped and removed because can't find: 423×42.
    [180281272] [17:20:49] Thread #1 : Skipped and removed because can't find: fragmentary–girl.
    [180281272] [17:20:51] Thread #1 : Skipped and removed because can't find: 402×42.
    [180281272] [17:20:53] Thread #1 : Skipped and removed because can't find: 472×42.
    [180281272] [17:20:55] Thread #1 : Skipped and removed because can't find: fragic–magic.
    [180281272] [17:20:58] Thread #1 : Skipped and removed because can't find: forever–devoted.
    [180281272] [17:20:59] Thread #1 : Skipped and removed because can't find: 42×452.
    [180281272] [17:21:02] Thread #1 : Skipped and removed because can't find: floral–vintage.

    here the hyphen is not normal and in other lines X is not typical X.
    i was able to store it but not perform actions on it.

    nvm my bad ignore this post

    store the data in the database in base64


Log in to reply