I am not sure as to why you are getting this. Btw, are you running on this GAE?
On Jan 14, 12:28 pm, David Marko <[email protected]> wrote: > I'm also getting back following error, when web2py tried to create a > new table in FirebirdSQL. > > Traceback (most recent call last): > File "c:\java\google_appengine\web2py\gluon\restricted.py", line 62, > in restricted > exec ccode in environment > File "c:/java/google_appengine/web2py/applications/firebird/models/ > db.py", line 9, in <module> > db=SQLDB('firebird://SYSDBA:master...@localhost:3050/c:/ > firebirdsql/CESTINA.FDB') > File "c:\java\google_appengine\web2py\gluon\sql.py", line 571, in > __init__ > self._execute('SET NAMES UTF8;') > File "c:\java\google_appengine\web2py\gluon\sql.py", line 570, in > <lambda> > self._execute=lambda *a,**b: self._cursor.execute(*a,**b) > ProgrammingError: (-104, 'isc_dsql_prepare: \n Dynamic SQL Error\n > SQL error code = -104\n Token unknown - line 1, column 5\n NAMES') > > David > > On 14 Led, 13:06, David Marko <[email protected]> wrote: > > > For collations (ordering) working properly one have to specify > > 'COLLATE' clause, when creating tables manualy. > > e.g. NAME VARCHAR(100) CHARACTER SET UTF8 COLLATE UNICODE); > > > But its not how web2py generates tables, so ordering the select > > statements doesnt work properly later. > > > David > > > On 14 Led, 12:41, Petros Diveris <[email protected]> wrote: > > > > Hi, > > > > I have done in the not so far past. What is it that you are after? > > > > Petros > > > > On Jan 14, 11:13 am, David Marko <[email protected]> wrote: > > > > > Hello, > > > > is there anyone using web2py with FirebirdSQL database? My question > > > > leads to some internationalisation issues, correct collations etc. > > > > > David --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
