On Mon, Jun 29, 2009 at 6:31 AM, mdipierro<mdipie...@cs.depaul.edu> wrote:
>
> Markus,
>
> sorry for my delay about this issue. Two questions:
> 1) will this make sqlite files created by web2py windows binary
> incompatible with web2py osx binary and or web2py running form source?

No.  The data in the database is not affected by this patch.  It only
changes how non-ASCII characters are treated in queries when using
UPPER, LOWER, LIKE, ...

> 2) Can you send me step by step instructions for including the file
> [7] that you linked into web2py_win.zip

• Download the source version of pysqlite from
http://oss.itsystementwicklung.de/trac/pysqlite/

• You need to have MSVC 2003 installed.

• Try building pysqlite  by calling
C:\Python25\python setup.py build_static
C:\Python25\python setup.py bdist_wininst

• Place the attached file sqlite3_unicode.c from my original email
into the 'amalgamation' directory.

• Apply the patch which is attached to this email.

• Rebuild pysqlite using
C:\Python25\python setup.py build_static
C:\Python25\python setup.py bdist_wininst

Now you have an installabel pysqlite extension in the 'dist' directory.

Kind regards,
Markus

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Attachment: sqlite3_unicode.patch
Description: Binary data

Reply via email to