You may want to check how the encoding is set in your database. Make sure you are using utf-8.
On Sat, Oct 10, 2009 at 9:43 PM, Rizwan <mr.mans...@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/ > > > from django.contrib.flatpages.models import FlatPage > from django.template import loader, RequestContext > from django.shortcuts import get_object_or_404 > from django.http import HttpResponse, HttpResponseRedirect > from django.conf import settings > from django.core.xheaders import populate_xheaders > from django.utils.safestring import mark_safe > import datetime, MySQLdb > DEFAULT_TEMPLATE = 'flatpages/default.html' > > def flatpage(request, url): > """ > Flat page view. > > Models: `flatpages.flatpages` > Templates: Uses the template defined by the ``template_name`` > field, > or `flatpages/default.html` if template_name is not defined. > Context: > flatpage > `flatpages.flatpages` object > """ > if not url.endswith('/') and settings.APPEND_SLASH: > return HttpResponseRedirect("%s/" % request.path) > if not url.startswith('/'): > url = "/" + url > f = get_object_or_404(FlatPage, url__exact=url, > sites__id__exact=settings.SITE_ID) > # If registration is required for accessing this page, and the > user isn't > # logged in, redirect to the login page. > if f.registration_required and not request.user.is_authenticated > (): > from django.contrib.auth.views import redirect_to_login > return redirect_to_login(request.path) > if f.template_name: > t = loader.select_template((f.template_name, > DEFAULT_TEMPLATE)) > else: > t = loader.get_template(DEFAULT_TEMPLATE) > > # To avoid having to always use the "|safe" filter in flatpage > templates, > # mark the title and content as already safe (since they are raw > HTML > # content in the first place). > f.title = mark_safe(f.title) > f.content = mark_safe(f.content) > > #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() > # custom code ends > c = RequestContext(request, { > 'flatpage': f, 'details':details, > }) > response = HttpResponse(t.render(c)) > populate_xheaders(request, response, FlatPage, f.id) > return response > > HTML CODE > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http:// > www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> > <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en"> > <head> > <meta http-equiv="content-type" content="text/html;charset=utf-8" / > > > <meta name="author" content="LoadFoO" /> > <meta name="description" content="Site description" /> > <meta name="keywords" content="key, words" /> > <title>{{flatpage.title}}</title> > <link rel="stylesheet" type="text/css" href="/css/style.css" > media="screen" /> > <link rel="shortcut icon" href="favicon.ico" /> > <script type="text/javascript" src="/js/textsizer.js"></script> > <script type="text/javascript" src="/js/rel.js"></script> > </head> > > <body> > <div id="wrap"> > <div id="top"> > <h2><a href="/homepage" title="Back to main page">Gujarati Quran</a></ > h2> > <div id="menu"> > <ul> > <li><a href="#" class="current">home</a></li> > <li><a href="#">about</a></li> > <li><a href="#">contact</a></li> > </ul> > </div> > </div> > <div id="content"> > <div style="float: right;"><a href="javascript:ts('body',1)">[+]</a> | > <a > href="javascript:ts('body',-1)">[-]</a></div> > <div id="left"> > <h2>{{flatpage.title}}</h2> > <p>{{flatpage.content}} > </p> > </div> > <div id="right"> > <ul id="nav"> > > {% for id,url, title,content in details %} > <li><a href="{{url}}">{{title|safe}}</a></li> > {% endfor %} > > </ul> > <div class="box"> > <h2 style="margin-top:17px">Recent Entries</h2> > <ul> > <li><a href="#">Recent Entries1</a> <i>01 Des > 06</i></li> > <li><a href="#">Recent Entries2</a> <i>01 Des > 06</i></li> > <li><a href="#">Recent Entries3</a> <i>01 Des > 06</i></li> > <li><a href="#">Recent Entries4</a> <i>01 Des > 06</i></li> > <li><a href="#">Recent Entries5</a> <i>01 Des > 06</i></li> > </ul> > </div> > </div> > <div id="clear"></div></div> > <div id="footer"> > <p>©<a href="http://www.rmansuri.net/"; > rel="external">rMansuri.net</a>. Valid <a href="http://jigsaw.w3.org/ > css-validator/check/referer" rel="external">CSS</a> & <a > href="http://validator.w3.org/check?uri=referer"; rel="external">XHTML</ > a></p> > </div> > </div> > > </body> > </html> > > On 10 Oct, 20:40, Joshua Russo <josh.r.ru...@gmail.com> wrote: > > On Sat, Oct 10, 2009 at 9:15 AM, Rizwan <br.riz...@googlemail.com> > wrote: > > > > > Hello Djangoer, > > > > > I am trying to create website with foreign language in it. I have > > > created model for content type and added one page in it. It saving > > > fine in database. When I have tried to write view model for this page. > > > Its showing me "?????" rather then foreign character. I am new born > > > baby in django world. any help or suggestion would be great. > > > > > you can see the this question mark athttp:// > beta.rmansuri.net/surah/001/ > > > > Without the code from your view (and possibly the template) it's > > too difficult to say. > > > --~--~---------~--~----~------------~-------~--~----~ 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
