search

coderholic / django-cities

Countries and cities of the world for Django projects
MIT License
920 stars 374 forks source link

search_names removed space #145

Closed fuji246 closed 7 years ago

fuji246 commented 7 years ago

Trying to search "san jose" but doesn't get any result, the search_names look like removed all spaces.

sqlite> select search_names from cities_light_city where "cities_light_city"."search_names" LIKE '%sanjose%';
sanjoseamerica sanjosecaliforniaamerica sanjosecaliforniarepublicamerica sanjosecaliforniarepublicunitedstates sanjosecaliforniarepublicunitedstatesofamerica sanjosecaliforniaunitedstates sanjosecaliforniaunitedstatesofamerica sanjosegoldenstateamerica sanjosegoldenstateunitedstates sanjosegoldenstateunitedstatesofamerica sanjosestateofcaliforniaamerica sanjosestateofcaliforniaunitedstates sanjosestateofcaliforniaunitedstatesofamerica sanjoseunitedstates sanjoseunitedstatesofamerica
southsanjosehillscaliforniaunitedstates southsanjosehillsunitedstates
blag commented 7 years ago

Judging from the names of your database tables you are using the Django-cities-light package and not this (just "Django-cities") package.

I think this is the project you want:

https://github.com/yourlabs/django-cities-light

Cheers!

fuji246 commented 7 years ago

oops, sorry for the confusion

blag commented 7 years ago

No worries, we all make mistakes. Let me know if the D-C-L devs aren't responsive and I'll take a look at it for ya. :)