I am running the latest beta but have seen this for several month. When I pull up the Filter/Sort dialog in the data grid and select a value from the list generated by clicking the … randomly an N gets prepended to the selection and added to the filter. Here is the list:
After double clicking AM here is what appeared in the Value box:
Then when adding the filter you get:
It is easy to fix, but a little annoying. As I said it seems random when it happens. The particular column I was using here in an NVARCHAR2(2).
Well, it's not random but it is a bug.
We should be showing N'AM in this case, without the leading quote.
The N is to tell Oracle to treat the string as NVARCHAR2 data instead of just VARCHAR2 data.
It looks like the '...' button is doing the right thing, but the "Add to Filter" is messing it up.
I think in the 25.X versions and before it just treated it as a generic string and added it to the filter as col = ‘value’ which historically was fine for NVARCHAR2 columns. Is N’value’ really needed or just technically more correct?
I haven't worked with NVARCHAR2 data much , but I think it depends on what string you enter, if that's really needed or not.
I'll have it fixed in the next beta or two.
1 Like
