Hi all, these probolems may be caused by unicode support by Oracle DB (or not - I don't know). The code works fine with MySQL and SQLite.
1. DAL migrations do not work if you change length of 'string' field. E.g. I have this: SQLField('komment', 'string', length=255) and I try to change it to SQLField('komment', 'string', length=512) and I get ORA-00911 error (bad symbol!) 2. When I try to migrate this field to SQLField('komment', 'text') I get same error: ORA-00911 3. I managed to migrate by removing this field definition, running the model (reload db admin page in browser) and pasting back the field definition SQLField('komment', 'text') Everything looked ok. Then I run data import script that inserts data from UTF-8 encoded file into this field. Script worked without problems. Then I try to see data in db admin page and get this error (the same error I get from any scripts that try to read data from this field): Traceback (most recent call last): File "c:\web2py\gluon\restricted.py", line 98, in restricted exec ccode in environment File "c:/web2py/applications/advantage/controllers/appadmin.py", line 196, in <module> File "c:\web2py\gluon\globals.py", line 75, in <lambda> self._caller = lambda f: f() File "c:/web2py/applications/advantage/controllers/appadmin.py", line 160, in select records=SQLTABLE (records,linkto,upload,orderby=True,_class='sortable')) File "c:\web2py\gluon\sqlhtml.py", line 634, in __init__ r = str(field.formatter(r)) ProgrammingError: LOB variable no longer valid after subsequent fetch --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---