good day everyone!
i am using postgresql-8.0beta2-dev3 windows port, with postgis-0.9
add-on. anyway, while trying to insert a table using shp2pgsql, i get
this error:
psql:temp.sql:38: ERROR: Unicode characters greater than or equal to
0x10000 are not supported
this is line 38 of temp.sql:
INSERT INTO "esiadminbounds"
(gid,"area","town","barangay","dens","pop90","popd90","pop95","popd95","pop97","popd97",the_geom)
VALUES
('37','1.424549','Bauan','Pitogo','0.00','0','4.03','0','0.00','0','0.00000000',GeometryFromText('MULTIPOLYGON(((120.955684569578
13.7725006999301 ,120.9554735709 13.7724626988676 ,120.955403570202
13.7724506990452 ,120.955229571123 13.7722566997561 ,120.95522957124
13.7722516993503 ,120.955229570082 13.7722466989339 ,120.955070571067
13.7722456995021 ,120.954931571036 13.7722436992655 ,120.954931571145
13.7722496995042 ,120.954897570853 13.7722496999685 ,120.954776571639
13.7722426992188 ,120.954677571648 13.7722366990558 ,120.954480571351
13.772390698913 ,120.954469571209 13.7723906997389 ,120.954469571997
13.7723996994764 ,120.954418571133 13.7724396989397 ,120.954417571232
13.7724396993554 ,120.954417571463 13.7724406991889 ,120.954378572154
13.7724706990999 ,120.95426457253 13.7723926996639 ,120.954264571623
13.7723886990838 ,120.954258572245 13.7723886990816 ,120.954236572153
13.7723726996713 ,120.954121572059 13.7724486995595 ,120.954069571652
13.7724736993948 ,120.954011571976 13.7725216990704 ,120.95388257267
13.7726066993588 ,120.953660572868 13.7726926990537 ,120.953463573
13.7727506992206 ,120.9533925736 13.7726866993123 ,120.953150573447
13.7724657000595 ,120.951933574673 13.772455700009 ,120.95057757599
13.7724446997878 ,120.9498125778 13.772822700065 ,120.949654577942
13.7728726991687 ,120.949389577744 13.7731016997272 ,120.949284578733
13.7731526999402 ,120.949072578313 13.7733046998845 ,120.948914579293
13.773354699701 ,120.948548579143 13.773526699911 ,120.94790157952
13.7737966994859 ,120.94790157952 13.7737966994859 ,120.947780579619
13.7738826991356 ,120.947781579913 13.7738846996532 ,120.947685579841
13.7739317000246 ,120.947491580821 13.7740436995634 ,120.947881580104
13.774638699372 ,120.947875580117 13.7752566999521 ,120.947691580716
13.7752806995878 ,120.947028581302 13.7758416993301 ,120.947027580884
13.7759436995362 ,120.946894581169 13.7760456991315 ,120.946156582435
13.7761686995377 ,120.9459695827 13.7765017001618 ,120.945968582131
13.7765786996464 ,120.946045582334 13.7768107000939 ,120.946124582967
13.7768376991713 ,120.946307582683 13.7769417002886 ,120.946251582585
13.7772756997884 ,120.945954583113 13.7782256996654 ,120.945768582824
13.7783786995522 ,120.945081583341 13.7786307001322 ,120.944682584804
13.7790646996173 ,120.944339584713 13.7792416999451 ,120.944046584884
13.7795226992718 ,120.94365058579 13.7796737001305 ,120.943646585685
13.7801367003654 ,120.942773586314 13.7806187000421 ,120.942145588119
13.7807477000423 ,120.94214758713 13.7807577000478 ,120.941949587394
13.7808966994756 ,120.941898587357 13.7808967003478 ,120.941898587357
13.7808967003478 ,120.941898588216 13.7809166993276 ,120.941882588124
13.7809167000871 ,120.941665588478 13.7811476998331 ,120.941711588532
13.7812886996558 ,120.941543588505 13.7814507000611 ,120.941326589029
13.7815886995907 ,120.941324588756 13.7818456998425 ,120.941222588855
13.7820557003543 ,120.941221588706 13.7820927004117 ,120.941221588706
13.7820927004117 ,120.941221589376 13.7821427003189 ,120.941375589047
13.782143700156 ,120.941373588147 13.7823437004827 ,120.941372588722
13.7824537001356 ,120.941366588069 13.782546699571 ,120.941532588916
13.7826416996957 ,120.942150587739 13.7830436993852 ,120.942317587143
13.7830216993328 ,120.942844587087 13.7829096996479 ,120.943083586784
13.78288770041 ,120.943081586605 13.7830987002521 ,120.943151586748
13.7833087003247 ,120.943076586407 13.7837057002219 ,120.942361587216
13.783442700435 ,120.942284587 13.7840957004391 ,120.94285558738
13.7843576993204 ,120.943071585955 13.7843127001598 ,120.943521586262
13.7847366993097 ,120.943521586245 13.7847146994284 ,120.943810585371
13.7847166997569 ,120.943810585371 13.7847166997569 ,120.943903585345
13.7847176992901 ,120.944144584882 13.7846126993342 ,120.944337584852
13.7844027002044 ,120.944554584503 13.7842646993978 ,120.944866584234
13.7841736999533 ,120.945274584138 13.7841296999024 ,120.945684583269
13.7838056997859 ,120.945901582998 13.7837366993142 ,120.946166582781
13.7835746992964 ,120.947193581247 13.7838646992182 ,120.947139581061
13.7846376991343 ,120.947401581608 13.784756700147 ,120.947952579977
13.7848316993526 ,120.948478580273 13.7849526990372 ,120.949122578952
13.7852156999324 ,120.949362578372 13.7852176990199 ,120.949746577914
13.785174699536 ,120.950011577631 13.7849886993708 ,120.950347577
13.7849216992745 ,120.950632576422 13.7852286994772 ,120.950726576421
13.785463699583 ,120.951227576775 13.7856786999332 ,120.951200575881
13.7859826996745 ,120.951866575863 13.7865966990361 ,120.951999575304
13.7865066990118 ,120.952093574652 13.7864386994373 ,120.952093574652
13.7864386994373 ,120.952323574909 13.7864406997791 ,120.953139573971
13.7862796997446 ,120.953332573766 13.7860706999998 ,120.95340657347
13.7858606996312 ,120.953551573542 13.7857216996243 ,120.953602572618
13.7853466990617 ,120.953795572484 13.7851846995361 ,120.953988573337
13.7851156990184 ,120.95398857209 13.7850226998197 ,120.953750573253
13.7848796997276 ,120.953607572719 13.7847616991326 ,120.953417573287
13.7845956994507 ,120.953273574182 13.7846416999209 ,120.95324957412
13.7845706992303 ,120.953322573111 13.784477699277 ,120.953420573375
13.7842676990993 ,120.953831573397 13.7838266996405 ,120.953952573106
13.7837107000407 ,120.954050572423 13.7835006994765 ,120.95436657194
13.782940699005 ,120.954462571619 13.7829416994551 ,120.954630571594
13.7828256988723 ,120.955182570773 13.7828306992094 ,120.955182571256
13.7827366988702 ,120.955040571871 13.7825716992204 ,120.955042571435
13.7823606991064 ,120.95494757102 13.7822196996958 ,120.955163570539
13.7821746993066 ,120.955526570713 13.7818026992352 ,120.955193570818
13.781518699102 ,120.955097570713 13.7815416999472 ,120.954931571985
13.7813526993233 ,120.954938571336 13.7805096990736 ,120.9547715721
13.7804846998353 ,120.954698571206 13.7805546993648 ,120.953644573335
13.78056969951 ,120.953622572818 13.7803346996677 ,120.953214574118
13.7803316989737 ,120.952977573773 13.7800716995148 ,120.952907573725
13.7799076995932 ,120.952643574605 13.7799056994063 ,120.952814573992
13.7795317000945 ,120.952789574581 13.7795316989895 ,120.952853573508
13.7794196995932 ,120.9528555735 13.7791627000368 ,120.953096573424
13.7786516990149 ,120.953281573442 13.7784736988715 ,120.953282573637
13.7783706997185 ,120.953601573015 13.7779116997421 ,120.953761572103
13.7777076999944 ,120.953842572654 13.7774766996664 ,120.953973572297
13.777477699384 ,120.954024572251 13.7775816995199 ,120.954393571325
13.7775076998911 ,120.954368571605 13.7773526989609 ,120.954950571445
13.776818699302 ,120.955108571302 13.7768206994694 ,120.955241570402
13.7766156998832 ,120.955399570547 13.7765916992347 ,120.955637570893
13.7763886989085 ,120.955638569915 13.7762856995845 ,120.956169569193
13.7756226993244 ,120.956014569471 13.7753136990787 ,120.955778570199
13.7752086997409 ,120.955281570097 13.7750506996421 ,120.955288570529
13.774177698878 ,120.954894571438 13.7742006996245 ,120.954605570957
13.7743006993236 ,120.954447571436 13.7742476989268 ,120.954529571934
13.7739657000161 ,120.954768571482 13.7736086995673 ,120.954981571241
13.773327699332 ,120.955139571405 13.7731756988832 ,120.955244570758
13.7732016992729 ,120.955270571289 13.7732536996206 ,120.955454570679
13.7732036996063 ,120.955621570382 13.7727656993817 ,120.955556570206
13.7725836998469 ,120.955556569924 13.7725496993171 ,120.955543569976
13.7725496997841 ,120.955543569786 13.7724996994471 ,120.955684569578
13.7725006999301 )))',-1) );
i really have no idea what a unicode character greater than or equal
to 0x10000 is. please help.
thanx in advance! have a nice day! :)
-Myk
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
