Firebird: maximum length of table names

Please enter any bugs here. We will check this daily!

Firebird: maximum length of table names

Postby skogvall on Fri Apr 29, 2005 8:55 am

Hi,

it seems to be a problem for myGeneration with table names exceeding 10 characters in firebird. Longer names get truncated.

Regards,
Bengt
skogvall
Staff Sergent
 
Posts: 39
Joined: Wed Sep 01, 2004 8:50 am
Location: Berlin, Germany

Postby mike.griffin on Fri Apr 29, 2005 1:07 pm

Are you sure you have Dialect=? set to the right dialect, actually, I think that is a limitation of Firebird.
User avatar
mike.griffin
Site Admin
 
Posts: 3290
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN

Postby skogvall on Fri Apr 29, 2005 1:59 pm

well, whatever it is, it worked ok in 1.0.0.4
skogvall
Staff Sergent
 
Posts: 39
Joined: Wed Sep 01, 2004 8:50 am
Location: Berlin, Germany

Postby mike.griffin on Fri Apr 29, 2005 2:16 pm

If you have any spaces in your connection string remove them, ie, trailing spaces like \"; \"
User avatar
mike.griffin
Site Admin
 
Posts: 3290
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN

Postby skogvall on Fri Apr 29, 2005 4:19 pm

There are no trailing spaces around the ;

The connection string is:
Code: Select all
User=sysdba;Password=masterkey;Datasource=localhost;Database=C:\\db\\moneytime.fdb;Port=3050;Dialect=1;Charset=ISO8859_1;Role=;Connection lifetime=200;Pooling=true;Packet Size=8192;
skogvall
Staff Sergent
 
Posts: 39
Joined: Wed Sep 01, 2004 8:50 am
Location: Berlin, Germany

Postby mike.griffin on Fri Apr 29, 2005 5:34 pm

I have seen this error before, it has happened when the wrong dialect was declared, just for kicks, try 3 and see what happens ...
User avatar
mike.griffin
Site Admin
 
Posts: 3290
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN

Postby skogvall on Fri Apr 29, 2005 7:20 pm

No change.
skogvall
Staff Sergent
 
Posts: 39
Joined: Wed Sep 01, 2004 8:50 am
Location: Berlin, Germany


Return to Defect Reporting (DON'T Post dOOdad bugs HERE)

Who is online

Users browsing this forum: No registered users and 1 guest

cron