Not sure how firebird handles it, but generally SET NAMES is about *client side* encoding, and does not influence the data (or operations) in/on the database (thus it has no effect on collation).
On Jan 14, 4:29 pm, mdipierro <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
