Hi,
I don't know if this has anything to do with Geoserver, but maybe someone can help me anyway.
I have a GetFeature request in my OpenLayers code and it has a CQL filter like this in it:
CQL_FILTER: "kuntanimi like '" + kunta + "'"
kunta is a variable. This works fine except when I put some scandinavian characters into that variable. kuntanimi is a field in a PostGis table (utf-8) and it does have scandinavian characters in it.
So what should I do to make that comparison also possible with strings containing scands? Is it something I have to do in Javascript (OpenLayers) or can I handle it somehow in Geoserver? I'm not good at these charset issues, sorry..
- mika -
Hi Mika,
First which version of GeoServer are you using?
If you are using a relatively new version can you try the following:
Go to the map preview tool for the layer in question. Open the advanced options tab (upper left hand corner) of the map, and try specifying the cql filter there. If the filter works the issue is probably how the ol map / layer is being setup. If you see the same problem then it is probably an issue on the geoserver side.
I don't have any scandenavian data around but i tried with some other extended latin characters and it seemed to work.
Hopefully this will help us narrow it down.
-Justin
Lehtonen, Mika wrote:
Hi,
I don't know if this has anything to do with Geoserver, but maybe someone can help me anyway.
I have a GetFeature request in my OpenLayers code and it has a CQL filter like this in it:
CQL_FILTER: "kuntanimi like '" + kunta + "'"
kunta is a variable. This works fine except when I put some scandinavian characters into that variable. kuntanimi is a field in a PostGis table (utf-8) and it does have scandinavian characters in it.
So what should I do to make that comparison also possible with strings containing scands? Is it something I have to do in Javascript (OpenLayers) or can I handle it somehow in Geoserver? I'm not good at these charset issues, sorry..
- mika -
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
Hi Justin,
this one is 1.7.0a. I manage to replicate this problem also with map preview. Filtered polygons which don't contain any scandinavian characters appear in the view but those which have them, don't.
- mika -
Justin Deoliveira kirjoitti:
Hi Mika,
First which version of GeoServer are you using?
If you are using a relatively new version can you try the following:
Go to the map preview tool for the layer in question. Open the advanced options tab (upper left hand corner) of the map, and try specifying the cql filter there. If the filter works the issue is probably how the ol map / layer is being setup. If you see the same problem then it is probably an issue on the geoserver side.
I don't have any scandenavian data around but i tried with some other extended latin characters and it seemed to work.
Hopefully this will help us narrow it down.
-Justin
Lehtonen, Mika wrote:
Hi,
I don't know if this has anything to do with Geoserver, but maybe someone can help me anyway.
I have a GetFeature request in my OpenLayers code and it has a CQL filter like this in it:
CQL_FILTER: "kuntanimi like '" + kunta + "'"
kunta is a variable. This works fine except when I put some scandinavian characters into that variable. kuntanimi is a field in a PostGis table (utf-8) and it does have scandinavian characters in it.
So what should I do to make that comparison also possible with strings containing scands? Is it something I have to do in Javascript (OpenLayers) or can I handle it somehow in Geoserver? I'm not good at these charset issues, sorry..
- mika -
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
GetFeatureInfo returns everything just right, including those scandinavian characters. I also tried OGC-filter. Neither CQL nor OGC filter works with scandinavian characters. Any hint, what would be causing this?
If I look into Geoserver log, I can see that scandinavian characters have switched into something else, so in that light I understand why the filters won't work properly.
- mika -
Lehtonen, Mika kirjoitti:
Hi Justin,
this one is 1.7.0a. I manage to replicate this problem also with map preview. Filtered polygons which don't contain any scandinavian characters appear in the view but those which have them, don't.
- mika -
Justin Deoliveira kirjoitti:
Hi Mika,
First which version of GeoServer are you using?
If you are using a relatively new version can you try the following:
Go to the map preview tool for the layer in question. Open the advanced options tab (upper left hand corner) of the map, and try specifying the cql filter there. If the filter works the issue is probably how the ol map / layer is being setup. If you see the same problem then it is probably an issue on the geoserver side.
I don't have any scandenavian data around but i tried with some other extended latin characters and it seemed to work.
Hopefully this will help us narrow it down.
-Justin
Lehtonen, Mika wrote:
Hi,
I don't know if this has anything to do with Geoserver, but maybe someone can help me anyway.
I have a GetFeature request in my OpenLayers code and it has a CQL filter like this in it:
CQL_FILTER: "kuntanimi like '" + kunta + "'"
kunta is a variable. This works fine except when I put some scandinavian characters into that variable. kuntanimi is a field in a PostGis table (utf-8) and it does have scandinavian characters in it.
So what should I do to make that comparison also possible with strings containing scands? Is it something I have to do in Javascript (OpenLayers) or can I handle it somehow in Geoserver? I'm not good at these charset issues, sorry..
- mika -
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Hi Mika,
So it seems like a bug where the encoding is getting missed or changed along the way. Would it be possible for you to provide a bit of your data which has some of the scandanavian characters in it? I could load it up here and see where the issue is occurring.
-Justin
Lehtonen, Mika wrote:
GetFeatureInfo returns everything just right, including those scandinavian characters. I also tried OGC-filter. Neither CQL nor OGC filter works with scandinavian characters. Any hint, what would be causing this?
If I look into Geoserver log, I can see that scandinavian characters have switched into something else, so in that light I understand why the filters won't work properly.
- mika -
Lehtonen, Mika kirjoitti:
Hi Justin,
this one is 1.7.0a. I manage to replicate this problem also with map preview. Filtered polygons which don't contain any scandinavian characters appear in the view but those which have them, don't.
- mika -
Justin Deoliveira kirjoitti:
Hi Mika,
First which version of GeoServer are you using?
If you are using a relatively new version can you try the following:
Go to the map preview tool for the layer in question. Open the advanced options tab (upper left hand corner) of the map, and try specifying the cql filter there. If the filter works the issue is probably how the ol map / layer is being setup. If you see the same problem then it is probably an issue on the geoserver side.
I don't have any scandenavian data around but i tried with some other extended latin characters and it seemed to work.
Hopefully this will help us narrow it down.
-Justin
Lehtonen, Mika wrote:
Hi,
I don't know if this has anything to do with Geoserver, but maybe someone can help me anyway.
I have a GetFeature request in my OpenLayers code and it has a CQL filter like this in it:
CQL_FILTER: "kuntanimi like '" + kunta + "'"
kunta is a variable. This works fine except when I put some scandinavian characters into that variable. kuntanimi is a field in a PostGis table (utf-8) and it does have scandinavian characters in it.
So what should I do to make that comparison also possible with strings containing scands? Is it something I have to do in Javascript (OpenLayers) or can I handle it somehow in Geoserver? I'm not good at these charset issues, sorry..
- mika -
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
That would be nice Justin.
Is it ok if I provide you a dump from the very same PostGIS table, I'm having troubles with? It's quite small.
- mika -
Justin Deoliveira kirjoitti:
Hi Mika,
So it seems like a bug where the encoding is getting missed or changed along the way. Would it be possible for you to provide a bit of your data which has some of the scandanavian characters in it? I could load it up here and see where the issue is occurring.
-Justin
Lehtonen, Mika wrote:
GetFeatureInfo returns everything just right, including those scandinavian characters. I also tried OGC-filter. Neither CQL nor OGC filter works with scandinavian characters. Any hint, what would be causing this?
If I look into Geoserver log, I can see that scandinavian characters have switched into something else, so in that light I understand why the filters won't work properly.
- mika -
Lehtonen, Mika kirjoitti:
Hi Justin,
this one is 1.7.0a. I manage to replicate this problem also with map preview. Filtered polygons which don't contain any scandinavian characters appear in the view but those which have them, don't.
- mika -
Justin Deoliveira kirjoitti:
Hi Mika,
First which version of GeoServer are you using?
If you are using a relatively new version can you try the following:
Go to the map preview tool for the layer in question. Open the advanced options tab (upper left hand corner) of the map, and try specifying the cql filter there. If the filter works the issue is probably how the ol map / layer is being setup. If you see the same problem then it is probably an issue on the geoserver side.
I don't have any scandenavian data around but i tried with some other extended latin characters and it seemed to work.
Hopefully this will help us narrow it down.
-Justin
Lehtonen, Mika wrote:
Hi,
I don't know if this has anything to do with Geoserver, but maybe someone can help me anyway.
I have a GetFeature request in my OpenLayers code and it has a CQL filter like this in it:
CQL_FILTER: "kuntanimi like '" + kunta + "'"
kunta is a variable. This works fine except when I put some scandinavian characters into that variable. kuntanimi is a field in a PostGis table (utf-8) and it does have scandinavian characters in it.
So what should I do to make that comparison also possible with strings containing scands? Is it something I have to do in Javascript (OpenLayers) or can I handle it somehow in Geoserver? I'm not good at these charset issues, sorry..
- mika -
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
Sure, that would be great.
Mika Lehtonen wrote:
That would be nice Justin.
Is it ok if I provide you a dump from the very same PostGIS table, I'm having troubles with? It's quite small.
- mika -
Justin Deoliveira kirjoitti:
Hi Mika,
So it seems like a bug where the encoding is getting missed or changed along the way. Would it be possible for you to provide a bit of your data which has some of the scandanavian characters in it? I could load it up here and see where the issue is occurring.
-Justin
Lehtonen, Mika wrote:
GetFeatureInfo returns everything just right, including those scandinavian characters. I also tried OGC-filter. Neither CQL nor OGC filter works with scandinavian characters. Any hint, what would be causing this?
If I look into Geoserver log, I can see that scandinavian characters have switched into something else, so in that light I understand why the filters won't work properly.
- mika -
Lehtonen, Mika kirjoitti:
Hi Justin,
this one is 1.7.0a. I manage to replicate this problem also with map preview. Filtered polygons which don't contain any scandinavian characters appear in the view but those which have them, don't.
- mika -
Justin Deoliveira kirjoitti:
Hi Mika,
First which version of GeoServer are you using?
If you are using a relatively new version can you try the following:
Go to the map preview tool for the layer in question. Open the advanced options tab (upper left hand corner) of the map, and try specifying the cql filter there. If the filter works the issue is probably how the ol map / layer is being setup. If you see the same problem then it is probably an issue on the geoserver side.
I don't have any scandenavian data around but i tried with some other extended latin characters and it seemed to work.
Hopefully this will help us narrow it down.
-Justin
Lehtonen, Mika wrote:
Hi,
I don't know if this has anything to do with Geoserver, but maybe someone can help me anyway.
I have a GetFeature request in my OpenLayers code and it has a CQL filter like this in it:
CQL_FILTER: "kuntanimi like '" + kunta + "'"
kunta is a variable. This works fine except when I put some scandinavian characters into that variable. kuntanimi is a field in a PostGis table (utf-8) and it does have scandinavian characters in it.
So what should I do to make that comparison also possible with strings containing scands? Is it something I have to do in Javascript (OpenLayers) or can I handle it somehow in Geoserver? I'm not good at these charset issues, sorry..
- mika -
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
Hi Justin,
I found a solution for my problem. After all, it was a Tomcat issue. Adding URIEncoding="UTF-8" into Tommy's connector did the trick. I found this site and followed the rules in it:
http://confluence.atlassian.com/display/DOC/Configuring+Tomcat's+URI+encoding
So if this wasn't just a coincidense, this could be an issue to share. Maybe this message will do that.
- mika -
Justin Deoliveira kirjoitti:
Hi Mika,
I loaded up the data you sent and I seemed to be able to filter it ok.
I tried the following filter:
kuntanimi EQ 'Dragsfjärd'
And it worked ok. I tried specifying the filter in a GetMap, GetFeature request. ANd also via the OpenLayers map preview, all worked.
Perhaps you should try upgrading to 1.7.1. Come to think of it I believe Andrea has introduced a character encoding fixes in this release.
Also, how are you running GeoServer? Standalone, or in a servlet container. I have sometimes had problems with extended character sets in tomcat if my locale is not set accordingly.
-Justin