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? thanx wochter 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@lists.maptools.org >> http://lists.maptools.org/mailman/listinfo/cartoweb-users >> > > _______________________________________________ Cartoweb-users mailing list Cartoweb-users@lists.maptools.org http://lists.maptools.org/mailman/listinfo/cartoweb-users
