about collate.
My understanding is that collate in table definition is not required.
In web2py you can specify it upon sorting with:
orderby='table.field collate de_de'
Massimo
On Jan 14, 9:29 am, mdipierro <mdipie...@cs.depaul.edu> 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 <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
-~----------~----~----~----~------~----~------~--~---
