What database is it? What are the database and database tables/columns
locales? You should give some more details so we can help. As a general idea,
check my questions above, and make suer the locale is unicode/utf-8.
--- Amit
ביום שישי 21 ספטמבר 2007, 19:07, נכתב על ידי drackett:
>
> I am trying to parse a last.fm xml file to get the artists, tracks,
> etc. into a django database. I am having an issue where foreign
> characters (Japanese, etc.) are being stored in the database as
> "?????" and not the correct values. I feel like I've tried everything,
> and am getting pretty frustrated, so I thought I would see if anyone
> had any ideas of what I might be doing wrong. here is my current code:
>
> import urllib
> import elementtree.ElementTree as ET
>
> try:
> tree =
> ET.parse(urllib.urlopen("http://ws.audioscrobbler.com/1.0/
> user/drackett/weeklytrackchart.xml"))
> x = tree.getroot()
>
> if not Update.objects.filter(ident=x.attrib.get('from')):
> global_id = x.attrib.get('from')
> for track in x:
> try:
> test =
> Artist.objects.get(mbid=track.find('artist').attrib.get('mbid'))
> except Artist.DoesNotExist:
> a = Artist(
> name =
> track.find('artist').text,
> mbid =
> track.find('artist').attrib.get('mbid'),
> )
> a.save()
> try:
> test =
> Track.objects.get(url=track.find('url').text)
> except Track.DoesNotExist:
> t = Track(
> name = track.find('name').text,
> artist =
> Artist.objects.get(mbid=track.find('artist').attrib.get('mbid')),
> url = track.find('url').text,
> )
> t.save()
> u = Update(
> track =
> Track.objects.get(url=track.find('url').text),
> position =
> track.find('chartposition').text,
> playcount =
> track.find('playcount').text,
> ident = global_id,
> )
> u.save()
> except:
> print "issue with import"
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
