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 <pdive...@gmail.com> 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 <dma...@tiscali.cz> 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 <dma...@tiscali.cz> 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 <pdive...@gmail.com> 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 <dma...@tiscali.cz> 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 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 -~----------~----~----~----~------~----~------~--~---