Thread: North America Weather Database V5 Manila (10-16-09) *Weather is fixed*
View Single Post
  #26 (permalink)  
Old 08-30-2009, 06:34 PM
saflang's Avatar
saflang
PPCGeeks Regular
Offline
Location: British Columbia
  
Join Date: Jan 2008
Posts: 163
Reputation: 125
saflang is keeping up the good worksaflang is keeping up the good work
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Re: North America Weather Database V2 Manila (8-27-09)
Pulled up the database with SQLite, looks like any city name with spaces in it has an extra special character  added that is screwing things up.
thus |NAM|CA|BC|PRINCE GEORGE is currently stored as |NAM|CA|BC|PRINCEÂ GEORGE

I'm not experienced enough with SQLite to be able to fix this up. Although I was able to export the database and remove all of the special characters. I just don't know how to import the file correctly to update the file. When I do an import (which takes a few minutes) nothing seems to change.

Thanks,

Quote:
Originally Posted by conflipper View Post
nope, but i will look into it, and try and find out, im trying to get accuweather api sources, and with that i could then be able to use postal codes and everything has well, so that will be good, i am in talks now wiht accuweather for this. so i am working on it.