CrazyCat
Joined: 11/06/2016 13:32:08
Messages: 4
Offline
|
No trouble for me,
Code:
sqlite> select * from geonames where name = 'Seattle';
5809844|Seattle|Seattle|Gorad Siehtl,SEA,Seatl,Seattle,Seattlum,Siatl,Siatul,Siehtl,Sietl,Sietla,Sietlas,Sijetl,Siyaatil,Séatl,ciyattil,shiatoru,si'aitala,siaeteul,sietʼli,siyatal,siyatala,syatl,xi ya tu,Σιάτλ,Горад Сіэтл,Сиатъл,Сиетл,Сиэтл,Сијетл,Сієтл,Սիեթլ,סיאטל,سياتل,سیئٹل,سیاتل,سیاٹل,सिअॅटल,सीऐटल,সিয়াটল,சியாட்டில்,ಸಿಯಾಟಲ್,ซีแอตเทิล,სიეტლი,ስያትል,ស៊ីតថល,シアトル,西雅圖,시애틀|47.60621|-122.33207|P|PPLA2|US||WA|033|||608660|56|56|America/Los_Angeles|2014-10-27
sqlite> select * from geonames where name = 'Tomahawk';
4133678|Tomahawk|Tomahawk||36.06063|-92.70655|P|PPL|US||AR|129|||0|301|302|America/Chicago|2010-09-05
4226771|Tomahawk|Tomahawk||34.11538|-84.41354|P|PPL|US||GA|057|||0|281|295|America/New_York|2006-01-15
4311038|Tomahawk|Tomahawk||37.86871|-82.5971|P|PPL|US||KY|159|||0|204|215|America/New_York|2006-01-15
4495230|Tomahawk|Tomahawk||34.71128|-78.3275|P|PPL|US||NC|163|||0|30|31|America/New_York|2006-01-15
4824824|Tomahawk|Tomahawk||39.53037|-78.04695|P|PPL|US||WV|003|||0|143|141|America/New_York|2006-01-15
5769789|Tomahawk|Tomahawk||44.21193|-103.52852|P|PPL|US||SD|081|||0|1470|1475|America/Denver|2006-01-15
10177450|Tomahawk|Tomahawk||-40.86699|147.75603|P|PPL|AU||06|61810|||0||12|Australia/Hobart|2015-04-07
5275884|Tomahawk|Tomahawk|Tomakhavk,tamhawk wyskansyn,twmahwk,Томахавк,تامهاوک، ویسکانسین,توماهوك|45.47108|-89.72986|P|PPL|US||WI|069|||3397|442|443|America/Chicago|2011-05-14
I think you have a trouble with your import, peharps because of persian, chinese, arabian, ... characters
|