XML Database Problem

badgermonkey · 12 Jan 2009 at 13:49

Ok, so I'm trying to sort out this database, however when I try to load the database into the program it's to be used for, I get the following error message:

UniCodeEncodeError:'latin-1' codec can't encode character u"\u2019' in position 161: Ordinal not in range(256)

I have NO idea what it's on about. Any help would be much appreciated.

GravyMonster · 12 Jan 2009 at 13:55

First hit

badgermonkey · 12 Jan 2009 at 14:01

Unfortunately, I don't have a clue where position 161 is supposed to be, it's meaningless to me. Any help on that please?

(btw thanks... that didn't show up when I searched googl myself first time :confused:

)

GravyMonster · 12 Jan 2009 at 14:10

Position 161 is the 161st character in the data which you're trying to insert into that field of the database.

\u2019 is one of the weird angled apostrophes Word sometimes uses instead of the usual '.

I'm not sure on the exact fix in MySQL as I've not used it, but it has something to do with the character encoding of the field in the database so may be worth have a Goog for that one.