Re: [pysqlite] Strings coming back as Unicode.

Hello,

Thanks for the inputs! By default SQLAlchemy/Elixir will have the
convert_to_unicode option set to false.

But thanks for letting me know the way to get at the underlying connection
object. The only trouble I have going with Unicode strings is that, when
there is a Database synchronization b/w client and the server, the server
side ZODB database is unable to Marshal unicode strings, or it could be the
XML RPC, I am not sure at this point.

Thank you for the help!

Regards,
Harish


On Mon, Nov 24, 2008 at 2:44 PM, Gerhard Häring <[email protected]> wrote:

> Harish Vishwanath wrote:
> > Hello All,
> >
> > I am using Pysqlite2.5.0 on top of Python 2.5 with Elixir and SqlAlchemy
> > as ORM packages.
> >
> >  >>> from elixir import *
> >  >>> class A(Entity):
> > ...     name = Field(String(40))
> > ...
> >  >>> metadata.bind = "sqlite:///c:\\temp.sqlite"
> >  >>> metadata.bind.echo = True
> >  >>> setup_all(True)
> >  >>> a = A(name="Ascii")
> >  >>> session.flush()
> >  >>> session.commit()
> >  >>> b = session.query(A)[0]
> >  >>> b.name <http://b.name>
> > u'Ascii'
> >  >>>
> >  >>> type(b.name <http://b.name>)
> > <type 'unicode'>
> >
> >
> > I have set proper options in SqlAlchemy/Elixir to NOT TO Convert strings
> > to Unicode automatically. [...]
>
> Which ones? I don't see any in your code.
>
> > I went through PySqlite's docs and found that
> > there is a connection.text_factory option which I can set to 'str' to
> > avoid this conversion. But since I use SQLAlchemy, I have no control
> > over the connection it obtains from Sqlite3 Dialect.
>
> Sure you have, you can still get at the raw DB-API connection object.
> Something like this might work:
>
> from elixir import *
> from sqlalchemy import create_engine
>
> def my_create_engine():
>     engine = create_engine("sqlite:///") # :memory:
>     engine.engine.connect().connection.connection.text_factory = str
>     return engine
>
> metadata.bind = my_create_engine()
> ...
>
> > Is there any way, to set connection.text_factory=str by default? Kindly
> > let me know.
>
> There isn't. And I agree with Roger: Unicode is the way to go for new
> applications.
>
> -- Gerhard
> _______________________________________________
> list-pysqlite mailing list
> list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
> http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
>

_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite