Toad for Oracle Professional v 188.8.131.52
I have a text string that in the database is lowercase, but (sometimes!) when I do a query the datagrid displays it as UPPERCASE (and sometimes it displays it as correct lowercase) . How do I forcethe datagrid to ALWAYS display it as it is in the database?
This query – selecting for lowercase ‘werner’ returns this record BUT (incorrectly) displays the manufacturer as UPPERCASE:
This query – selecting for UPPERCASE “WERNER’ does not return this tool (correctly in this case as werner is lowercase):
In this query – selecting for the tool # displays it as LOWERCASE (correctly):
My question is - How do I force the datagrid to ALWAYS display the correct case ?