query on char field

[Amod]

Version dotNetDirect9.0\9.3.230

I am facing issue with where clause UPPER("COLUMN_NAME") = 'S', the column type is char(4), as it returns no rows. The same works from my Oracle sql client.

I changed 'S' with 'S ' (S with 4 spaces) and it works.

Any suggestions?

[Shalex]

Try adding "Trim Fixed Char=false;" to your connection string. Does this help?

Refer to https://www.devart.com/dotconnect/oracl ... tring.html.