Dear List I have been compiling my own SQLite version with support for diacritic sorting and searching for the iPhone. This has worked well so far, described here in a blog post: http://pp.hillrippers.ch/blog/2009/08/08/Static+SQLite+Library+with+Unicode+Support+for+the+iPhone/
Now when I compile and run this library on the iPad or iPad simulator, my app crashes when preparing queries, giving the error "no such table: <tablename>". It seems that the library only sees the "last" table in the database, so if I change the order in which tables are created, the app crashes at preparing the first statement that requires any non-last created table. I can see however using sqlite3 from command line that these tables do exist in the database file. As mentioned, the same code works on the iPhone/iPhone simulator and the same code also works when linking against Apples libsqlite3 library instead of my own. It doesn't help to not use the unicode extensions, so basically compiling amalgamation 3.6.23.1 for the iPad creates a non-functional library while it works for the iPhone. Does anyone have an idea what might be going on and how I might be able to fix this? Thanks a lot! Pascal -- Pascal Pfiffner http://www.iib.unibe.ch/ http://pp.hillrippers.ch/ http://twitter.com/phaseofmatter/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users