Re: Foreign language in View Model.

On Sat, Oct 10, 2009 at 6:43 PM, Rizwan <mr.mansuri@googlemail.com> wrote:

I am trying to extend flatpage view...I have added custom code
here..you can see navigation showing question mark here
http://beta.rmansuri.net/homepage/


[snip]
   #custom code start
   db = MySQLdb.connect
(user='rmansuri_gq',db='rmansuri_gq',passwd='riz#wan1712',host='localhost')
   cursor = db.cursor()
   cursor.execute("SELECT * from django_flatpage where id != 2")
   details = [row for row in cursor.fetchall()]
   db.close()

Why are you bypassing the Django ORM and creating your own DB connection, etc. for this?  That's a whole lot of work and you lose all the nice things the ORM provides you with, including setting up the DB connection so that MySQL returns data utf-8 encoded instead of its default latin1.  The question marks are coming from the fact that the data you have can't be encoded in latin1, so MySQL returns ? for each Unicode character it can't send over a connection that only accepts latin1.

You could fix your db connection to return utf8, but this whole chunk would be much more simply written as:

details = FlatPage.objects.exclude(pk=2)

and then in your template instead of:

   {% for id,url, title,content in details %}
       <li><a href="{{url}}">{{title|safe}}</a></li>

   {% endfor %}

you would use:

   {% for fp in details %}
       <li><a href="{{fp.url}}">{{fp.title|safe}}</a></li>
   {% endfor %}

Karen

--~--~---------~--~----~------------~-------~--~----~
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 django-users+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---