sql using characters like é and ã

[tjerk]

Hello, I am switching from VB to python.
I managed to crank my files into a sqlite
dbase, converting the original names to
unicode with s=unicode(s,"latin-1").
Everything is working fine, but when
I query the dbase with dbapi2 and want
to retrieve names this way:
'Select * from table where name like "José%"´
The ´José's don´t appear in my list.
Other names lets say "Maria%" works fine.
Also "João%" doesn´t work. 
Anybody knows a trick?

Herdsman in Brazil

-- 
http://mail.python.org/mailman/listinfo/python-list

Re: sql using characters like é and ã

[tjerk]

I will try it with the "José".decode("latin-1").encode("utf-8")
Utf-8 is the same as Unicode?
Herdsman again

-- 
http://mail.python.org/mailman/listinfo/python-list

How to format and print text.

[tjerk]

Have been messing with python, but could´nt find out
how to do printing with different Fonts.
Any suggestions?

Herdsman

-- 
http://mail.python.org/mailman/listinfo/python-list

Re: What's The Best Editor for python

[tjerk]

PythonStudent wrote:
> Hi,
> Can one of you say to me what's the best editor for editing the python
> programs ( for linux or windows ), and if you can send it to me to the
> adresse [EMAIL PROTECTED]
>
>
>
>
Why don´t you try the editor wich comes with Pythoncard.
Or Notepad++   Thanks

-- 
http://mail.python.org/mailman/listinfo/python-list