I am trying to add layer through SQL VIEW GeoServer.
Everything is fine just, GeoServer is not able to take some chars correctly.
When name parameter includes dash "-" character, the WMS not able to show layer on map.
select * from public."MyLayer" where name like '%%name%'
In PostgreSQL, the query is working, but in SQL, view it does not show.