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
-~----------~----~----~----~------~----~------~--~---
