I have used the lookup wizard in previous versions and the match between the tables was case sensitive.
I am now using version 10.92 where the lookup wizard does not map the values unless the case matches.
It is not a matter of DB configuration since the old and new applications point to the same DB.
By setting $dDebug = true I can see the query done by the lookup wizard:
SELECT
`BU`, `virtual company`, `last update`
FROM `bu-virtual company` WHERE ( ( ( ( BU='BUSIT_edg' ) ) ) ) If I hardcode this query in a php script in phprunner it returns the desired value (EDGE), but the list page shows BUSIT_edg instead.
Is there a setting to be set to force the lookup wizard to be case insensitive?
TIA
Marco