StreetFerret

You are not logged in. Would you like to login or register?



1/03/2021 10:49 pm  #11


Re: Character encoding problem for international street names

The issue was that the database was using a case-insensitive and accent-insensitive column collation.  I've now migrated the street table to use a case-insensitive but accent-sensitive collation.  So, it will still group together streets that have different case sensitivity, but will properly tell the difference between streets with accent differences.  I've added Lidingö to the queue for a re-load, however, it's in line behind the other 13,000 cities that are currently being reloaded, so it's going to be several days before that gets corrected.  Thanks for the detailed troubleshoot!

 

1/08/2021 6:13 am  #12


Re: Character encoding problem for international street names

Well, it took some time to loop through all cities, but now they look ok, and Lidingö is also back to 562, with both Stamstigen and Stömstigen, great!

 

Board footera

 

Powered by Boardhost. Create a Free Forum