[Aadarsh]

Hi,

Applying filters is simple. You don’t have to right click on column header every time and follow all these steps to apply a new filter.

You can just click on filter button in the toolbar and it will open up the dialog to apply filters. Choose the column header and write the respective filter to be applied.
Moreover not differentiating b/w quick brown fox and ‘quick brown fox’ is in order to give correct filter results. All mysql syntax compliant people will add %% at the beginning and end. Though a request to add %LIKE% in the dropdown can be considered but we can’t promise the timeline when we will be implementing it.

[Aadarsh]

Hi,

 

The UTF-8 character set supports the UK currency sign. If the table and database are set to UTF-8, you can try entering the data directly into tables through SQLyog and check if it converts it to Â£.

 

I guess the data is being entered from somewhere else or where it is being fetched, there is some character set mismatch. Somewhere character set is ISO-8859-1 (most probably ) . If you are fetching the data on a HTML page, then check the encoding( content type )  in the head of the page or the content type in the header which the server is sending. 

[Author]

Posts