[Cartoweb-users] locate autocompleter and special characters

wochter wochter at seznam.cz
Fri Oct 31 08:33:24 EDT 2008

Yes, you are right,
Postgres doesn't support user defined collate with actual version :-(
But I wrote function wox_unaccent() to solve my problem.
I can use it like this:
SELECT * FROM table WHERE wox_unaccent(column) = wox_unaccent('anytext');

But I realy don't know how to change function getList.
I cannot understand this function :-(
Could you help me please?



Oliver Christen  wrote / napísal(a):
> Hi
> isnt this a sql problem ?
> usualy string are stored simplified in the database and the querystring
> is simply simplified for the search.
> but since you seem to want it the other way around (getting a specific
> string based on a simplified querystring),
> the closest thing that comes to my mind is this:
> http://www.postgresql.org/docs/8.3/static/fuzzystrmatch.html
> which allow to search for string which are close to what you search.
> the query is triggered in function getList in the php, so you can
> certainly add some more complex sql queries / treatments.
> regards
> Oliver
>> Hi,
>> I'd like to use locate plugin.
>> But there are the special (czech, slovak,...) characters like:
>> ščžýáíéŠČŽÝÁÍÉ.
>> I have names of towns stored in postgres with them original czech names.
>> Id like to substitute that chars by standard chars: č-c š-s ž-z....
>> Now I have to write: Čáslav when I want to find this town.
>> I'd like to write: caslav.
>> I found Extra local autocomplete options:
>> - choices
>> - partialSearch
>> - fullSsearch
>> - partialChars
>> - ignoreCase
>> but no one from that helps me solve my problem.
>> Is there any way to do that please?
>> thanx
>> wochter
>> _______________________________________________
>> Cartoweb-users mailing list
>> Cartoweb-users at lists.maptools.org
>> http://lists.maptools.org/mailman/listinfo/cartoweb-users

More information about the Cartoweb-users mailing list