error: unicode characters greater than or equal to 0x10000

Michael Mallete

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:3 8: ERROR: Unicode characters greater than or equal to
0x10000 are not supported
this is line 38 of temp.sql:

INSERT INTO "esiadminbounds "
(gid,"area","to wn","barangay", "dens","pop90", "popd90","pop95 ","popd95","pop 97","popd97",th e_geom)
VALUES ('37','1.424549 ','Bauan','Pito go','0.00','0', '4.03','0','0.0 0','0','0.00000 000',GeometryFr omText('MULTIPO LYGON(((120.955 684569578
13.772500699930 1 ,120.9554735709 13.772462698867 6 ,120.9554035702 02
13.772450699045 2 ,120.9552295711 23 13.772256699756 1 ,120.9552295712 4
13.772251699350 3 ,120.9552295700 82 13.772246698933 9 ,120.9550705710 67
13.772245699502 1 ,120.9549315710 36 13.772243699265 5 ,120.9549315711 45
13.772249699504 2 ,120.9548975708 53 13.772249699968 5 ,120.9547765716 39
13.772242699218 8 ,120.9546775716 48 13.772236699055 8 ,120.9544805713 51
13.772390698913 ,120.9544695712 09 13.772390699738 9 ,120.9544695719 97
13.772399699476 4 ,120.9544185711 33 13.772439698939 7 ,120.9544175712 32
13.772439699355 4 ,120.9544175714 63 13.772440699188 9 ,120.9543785721 54
13.772470699099 9 ,120.9542645725 3 13.772392699663 9 ,120.9542645716 23
13.772388699083 8 ,120.9542585722 45 13.772388699081 6 ,120.9542365721 53
13.772372699671 3 ,120.9541215720 59 13.772448699559 5 ,120.9540695716 52
13.772473699394 8 ,120.9540115719 76 13.772521699070 4 ,120.9538825726 7
13.772606699358 8 ,120.9536605728 68 13.772692699053 7 ,120.953463573
13.772750699220 6 ,120.9533925736 13.772686699312 3 ,120.9531505734 47
13.772465700059 5 ,120.9519335746 73 13.772455700009 ,120.9505775759 9
13.772444699787 8 ,120.9498125778 13.772822700065 ,120.9496545779 42
13.772872699168 7 ,120.9493895777 44 13.773101699727 2 ,120.9492845787 33
13.773152699940 2 ,120.9490725783 13 13.773304699884 5 ,120.9489145792 93
13.773354699701 ,120.9485485791 43 13.773526699911 ,120.9479015795 2
13.773796699485 9 ,120.9479015795 2 13.773796699485 9 ,120.9477805796 19
13.773882699135 6 ,120.9477815799 13 13.773884699653 2 ,120.9476855798 41
13.773931700024 6 ,120.9474915808 21 13.774043699563 4 ,120.9478815801 04
13.774638699372 ,120.9478755801 17 13.775256699952 1 ,120.9476915807 16
13.775280699587 8 ,120.9470285813 02 13.775841699330 1 ,120.9470275808 84
13.775943699536 2 ,120.9468945811 69 13.776045699131 5 ,120.9461565824 35
13.776168699537 7 ,120.9459695827 13.776501700161 8 ,120.9459685821 31
13.776578699646 4 ,120.9460455823 34 13.776810700093 9 ,120.9461245829 67
13.776837699171 3 ,120.9463075826 83 13.776941700288 6 ,120.9462515825 85
13.777275699788 4 ,120.9459545831 13 13.778225699665 4 ,120.9457685828 24
13.778378699552 2 ,120.9450815833 41 13.778630700132 2 ,120.9446825848 04
13.779064699617 3 ,120.9443395847 13 13.779241699945 1 ,120.9440465848 84
13.779522699271 8 ,120.9436505857 9 13.779673700130 5 ,120.9436465856 85
13.780136700365 4 ,120.9427735863 14 13.780618700042 1 ,120.9421455881 19
13.780747700042 3 ,120.9421475871 3 13.780757700047 8 ,120.9419495873 94
13.780896699475 6 ,120.9418985873 57 13.780896700347 8 ,120.9418985873 57
13.780896700347 8 ,120.9418985882 16 13.780916699327 6 ,120.9418825881 24
13.780916700087 1 ,120.9416655884 78 13.781147699833 1 ,120.9417115885 32
13.781288699655 8 ,120.9415435885 05 13.781450700061 1 ,120.9413265890 29
13.781588699590 7 ,120.9413245887 56 13.781845699842 5 ,120.9412225888 55
13.782055700354 3 ,120.9412215887 06 13.782092700411 7 ,120.9412215887 06
13.782092700411 7 ,120.9412215893 76 13.782142700318 9 ,120.9413755890 47
13.782143700156 ,120.9413735881 47 13.782343700482 7 ,120.9413725887 22
13.782453700135 6 ,120.9413665880 69 13.782546699571 ,120.9415325889 16
13.782641699695 7 ,120.9421505877 39 13.783043699385 2 ,120.9423175871 43
13.783021699332 8 ,120.9428445870 87 13.782909699647 9 ,120.9430835867 84
13.78288770041 ,120.9430815866 05 13.783098700252 1 ,120.9431515867 48
13.783308700324 7 ,120.9430765864 07 13.783705700221 9 ,120.9423615872 16
13.783442700435 ,120.942284587 13.784095700439 1 ,120.9428555873 8
13.784357699320 4 ,120.9430715859 55 13.784312700159 8 ,120.9435215862 62
13.784736699309 7 ,120.9435215862 45 13.784714699428 4 ,120.9438105853 71
13.784716699756 9 ,120.9438105853 71 13.784716699756 9 ,120.9439035853 45
13.784717699290 1 ,120.9441445848 82 13.784612699334 2 ,120.9443375848 52
13.784402700204 4 ,120.9445545845 03 13.784264699397 8 ,120.9448665842 34
13.784173699953 3 ,120.9452745841 38 13.784129699902 4 ,120.9456845832 69
13.783805699785 9 ,120.9459015829 98 13.783736699314 2 ,120.9461665827 81
13.783574699296 4 ,120.9471935812 47 13.783864699218 2 ,120.9471395810 61
13.784637699134 3 ,120.9474015816 08 13.784756700147 ,120.9479525799 77
13.784831699352 6 ,120.9484785802 73 13.784952699037 2 ,120.9491225789 52
13.785215699932 4 ,120.9493625783 72 13.785217699019 9 ,120.9497465779 14
13.785174699536 ,120.9500115776 31 13.784988699370 8 ,120.950347577
13.784921699274 5 ,120.9506325764 22 13.785228699477 2 ,120.9507265764 21
13.785463699583 ,120.9512275767 75 13.785678699933 2 ,120.9512005758 81
13.785982699674 5 ,120.9518665758 63 13.786596699036 1 ,120.9519995753 04
13.786506699011 8 ,120.9520935746 52 13.786438699437 3 ,120.9520935746 52
13.786438699437 3 ,120.9523235749 09 13.786440699779 1 ,120.9531395739 71
13.786279699744 6 ,120.9533325737 66 13.786070699999 8 ,120.9534065734 7
13.785860699631 2 ,120.9535515735 42 13.785721699624 3 ,120.9536025726 18
13.785346699061 7 ,120.9537955724 84 13.785184699536 1 ,120.9539885733 37
13.785115699018 4 ,120.9539885720 9 13.785022699819 7 ,120.9537505732 53
13.784879699727 6 ,120.9536075727 19 13.784761699132 6 ,120.9534175732 87
13.784595699450 7 ,120.9532735741 82 13.784641699920 9 ,120.9532495741 2
13.784570699230 3 ,120.9533225731 11 13.784477699277 ,120.9534205733 75
13.784267699099 3 ,120.9538315733 97 13.783826699640 5 ,120.9539525731 06
13.783710700040 7 ,120.9540505724 23 13.783500699476 5 ,120.9543665719 4
13.782940699005 ,120.9544625716 19 13.782941699455 1 ,120.9546305715 94
13.782825698872 3 ,120.9551825707 73 13.782830699209 4 ,120.9551825712 56
13.782736698870 2 ,120.9550405718 71 13.782571699220 4 ,120.9550425714 35
13.782360699106 4 ,120.9549475710 2 13.782219699695 8 ,120.9551635705 39
13.782174699306 6 ,120.9555265707 13 13.781802699235 2 ,120.9551935708 18
13.781518699102 ,120.9550975707 13 13.781541699947 2 ,120.9549315719 85
13.781352699323 3 ,120.9549385713 36 13.780509699073 6 ,120.9547715721
13.780484699835 3 ,120.9546985712 06 13.780554699364 8 ,120.9536445733 35
13.78056969951 ,120.9536225728 18 13.780334699667 7 ,120.9532145741 18
13.780331698973 7 ,120.9529775737 73 13.780071699514 8 ,120.9529075737 25
13.779907699593 2 ,120.9526435746 05 13.779905699406 3 ,120.9528145739 92
13.779531700094 5 ,120.9527895745 81 13.779531698989 5 ,120.9528535735 08
13.779419699593 2 ,120.9528555735 13.779162700036 8 ,120.9530965734 24
13.778651699014 9 ,120.9532815734 42 13.778473698871 5 ,120.9532825736 37
13.778370699718 5 ,120.9536015730 15 13.777911699742 1 ,120.9537615721 03
13.777707699994 4 ,120.9538425726 54 13.777476699666 4 ,120.9539735722 97
13.777477699384 ,120.9540245722 51 13.777581699519 9 ,120.9543935713 25
13.777507699891 1 ,120.9543685716 05 13.777352698960 9 ,120.9549505714 45
13.776818699302 ,120.9551085713 02 13.776820699469 4 ,120.9552415704 02
13.776615699883 2 ,120.9553995705 47 13.776591699234 7 ,120.9556375708 93
13.776388698908 5 ,120.9556385699 15 13.776285699584 5 ,120.9561695691 93
13.775622699324 4 ,120.9560145694 71 13.775313699078 7 ,120.9557785701 99
13.775208699740 9 ,120.9552815700 97 13.775050699642 1 ,120.9552885705 29
13.774177698878 ,120.9548945714 38 13.774200699624 5 ,120.9546055709 57
13.774300699323 6 ,120.9544475714 36 13.774247698926 8 ,120.9545295719 34
13.773965700016 1 ,120.9547685714 82 13.773608699567 3 ,120.9549815712 41
13.773327699332 ,120.9551395714 05 13.773175698883 2 ,120.9552445707 58
13.773201699272 9 ,120.9552705712 89 13.773253699620 6 ,120.9554545706 79
13.773203699606 3 ,120.9556215703 82 13.772765699381 7 ,120.9555565702 06
13.772583699846 9 ,120.9555565699 24 13.772549699317 1 ,120.9555435699 76
13.772549699784 1 ,120.9555435697 86 13.772499699447 1 ,120.9556845695 78
13.772500699930 1 )))',-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 8: explain analyze is your friend

Nov 23 '05 #1

Subscribe Reply

1552

Similar topics

25954

convert Unicode to lower/uppercase?

by: Hallvard B Furuseth | last post by:

Has someone got a Python routine or module which converts Unicode strings to lowercase (or uppercase)? What I actually need to do is to compare a number of strings in a case-insensitive manner, so I assume it's simplest to convert to lower/upper first. Possibly all strings will be from the latin-1 character set, so I could convert to 8-bit latin-1, map to lowercase, and convert back, but that seems rather cumbersome.

Python

1761

Wide Unicode build for Windows available somewhere?

by: cwittern | last post by:

Hi there, I am trying to locate a windows binary of a recent python (2.4 preferred, but not essential) with support for Unicode characters with values greater than 0x10000. I have tested the python.org binaries and those from Activestate, both give me a traceback on unichr(0x10000) and tell me its a "narrow" build. Any pointers appreciated. Chris

Python

8541

unicode converting

by: Maxim Kasimov | last post by:

there are a few questions i can find answer in manual: 1. how to define which is internal encoding of python unicode strings (UTF-8, UTF-16 ...) 2. how to convert string to UCS-2 (Python 2.2.3 on freebsd4) -- Best regards, Maxim

Python

5279

Creating a Unicode Surrogate Pair

by: Chris Mullins | last post by:

I've got a big unicode character, and i'm trying to build it into a string. The unicode character is in the range "0x10400", so it's going to require a surrogate pair. I've been through all the logic to iterate over strings that already have these pairs in them, but how do I encode this Unicode Character INTO the string? The string is UTF-8 encoded, but none of the things I've trided using the encoders seems to work right...

.NET Framework

49732

std::string vs. Unicode UTF-8

by: Wolfgang Draxinger | last post by:

I understand that it is perfectly possible to store UTF-8 strings in a std::string, however doing so can cause some implicaions. E.g. you can't count the amount of characters by length() | size(). Instead one has to iterate through the string, parse all UTF-8 multibytes and count each multibyte as one character. To address this problem the GTKmm bindings for the GTK+ toolkit have implemented a own string class Glib::ustring...

C / C++

2988

Unicode character conversation

by: Antimon | last post by:

Hi, I need to convert a unicode string to ASCII. I can simply use getbytes method to do that but i would use some characters since Unicode is 16bit. But i thought there might be some way to convert characters like "ü" to "u" or, "å" to "a". Or a chance i can find a conversation table? Thanks.

C# / C Sharp

3251

Unicode, encodings, and asian languages: need some help.

by: apprentice | last post by:

Hello, I'm writing an class library that I imagine people from different countries might be interested in using, so I'm considering what needs to be provided to support foreign languages, including asian languages (chinese, japanese, korean, etc). First of all, strings will be passed to my class methods, some of which based on the language (and on the encoding) might contain characters that require more that a single byte.

.NET Framework

5337

DB2 Error -102

by: BlueCrossChris | last post by:

I am receiving the following error: The string that I am trying to insert is 600 bytes long. The column on my DB2 table is physically a combination of columns that equal 600 bytes - but logically is a single 600 byte column. On the mainframe side of our application, we are able to insert, select, etc to this column without any problems, but I can't get the application to insert on the web side. Any suggestions? A co-worker suggested...

MySQL Database

4533

Python's handling of unicode surrogates

by: Adam Olsen | last post by:

As was seen in another thread, there's a great deal of confusion with regard to surrogates. Most programmers assume Python's unicode type exposes only complete characters. Even CPython's own functions do this on occasion. This leads to different behaviour across platforms and makes it unnecessarily difficult to properly support all languages. To solve this I propose Python's unicode type using UTF-16 should have gaps in its index,...

Python

9647

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9492

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10360

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10163

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7510

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6744

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5397

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5532

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3668

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP