Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Ticket #345 (closed defect: invalid)

Opened 13 years ago

Last modified 12 years ago

Unicode with SQLIite

Reported by: Ivo Looser Owned by: anonymous
Priority: normal Milestone: 0.9
Component: SQLObject Version:
Severity: normal Keywords:
Cc: ivo.looser@…

Description

I whould like to use Unicode in SQLite on my windows python2.4 installation.

Turbogear is 0.9dev.

My modell is the following:

from sqlobject import *
from turbogears.database import PackageHub

hub = PackageHub("test")
__connection__ = hub

class Navigation(SQLObject):
    name = UnicodeCol(alternateID=True, unique=True, length=40)
    target = UnicodeCol(length=20)
    sortorder = IntCol()
    active = BoolCol()

the controller hold a method index like this:

    def index(self):
        navigations = [nav.name for nav in Navigation.select(orderBy=Navigation.q.sortorder)] #[u'test', u'ä']
        return dict(navs = navigations)
        

dev.cfg

kid.outputformat ="xhtml"
kid.encoding="iso-8859-1"
tg.outputformat="html-strict"

when i use navigations = [u'test', u'über uns']

i comes right in my templates.

when i use ü from sqlite then it comes (here is a square)ber uns

Change History

comment:1 Changed 13 years ago by anonymous

  • Milestone set to 0.9

comment:2 Changed 13 years ago by Ivo Looser <ivo.looser@…>

id looks like it is a Windows issue same way on Linux works great...

comment:3 Changed 13 years ago by godoy

I believe that it is SQLite version dependent. You need pysqlite2 and SQLite 3.X to be able to use Unicode, IIRC.

Do you still have this problem or is it fixed for you in newer versions of TG?

comment:4 Changed 13 years ago by jorge.vargas

  • Status changed from new to closed
  • Resolution set to invalid

closing this it seems to be a dependancies error and the original autor or someone else doesn't seems to be having it.

Note: See TracTickets for help on using tickets.