I quote from Firebird's documentation:
Creating a Database
You can define the default character set for a new database in the
CREATE DATABASE statement:
CREATE DATABASE <database>
USER <username>
PASSWORD <password>
PAGE_SIZE <pagesize>
DEFAULT CHARACTER SET <charset>
For example:
CREATE DATABASE localhost:meter
USER SYSDBA
PASSWORD masterkey
PAGE_SIZE 4096
DEFAULT CHARACTER SET ISO8859_1;
>From now on, any VARCHAR or CHAR field will default to the ISO8859_1
character set. You can, however, specify a special character set for
each column:
CREATE TABLE users (
CZECH_NAME VARCHAR(50) CHARACTER SET ISO8859_2,
I also remember reading somewhere that as of Firebird 2.something you
can specify this in some variety of settings file. Apologies, can't
get my self to dig any further in the docs, it's somwhere there!
On Jan 14, 5:45 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> You are right. What I mean to say is that normally when you define a
> table, for each table, you specify both charset and collation. You can
> (I think) specify charset (clientside encoding) once for all with set
> names and collation when you need it (at sorting or upper or lower).
>
> Massimo
>
> On Jan 14, 11:15 am, achipa <attila.cs...@gmail.com> wrote:
>
> > Not sure howfirebirdhandles 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 <mdipie...@cs.depaul.edu> wrote:
>
> > > I have not done the tests onfirebirdmyself 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 tofirebirdmanually 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
-~----------~----~----~----~------~----~------~--~---
