I have not done the tests on firebird myself but my understanding was that by calling the following SQL
SET NAMES UTF8; it is no longer necessary to specify a collate for every column. Is this wrong? On your system this produces an error. Why is that? Can you issue the statement to firebird manually outside web2py? Massimo On Jan 14, 7:06 am, Petros Diveris <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
