Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By zbrooks on
My company has a pretty complicated website and one of the functions that has been written is a product search tool. for some reason, when entering any search term into the database that is listed as a number the letter e and a number (1e9) for example returns no results even though there are products that match it. Other searches like it (1a9) for example return results normally. It has been suggested that because #e# is a form of scientific notation that the DB abstraction layer might be filtering it, or for that matter MySQL might be. Can any one confirm this, and if so offer a possible solution to filter it?
