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
-~----------~----~----~----~------~----~------~--~---
