[Firebird-devel] Default for timestamp col causes error - known bug?

2011-04-28 Thread Kjell Rilbe
FB 2.1 using isql, connect with utf8 to a database with default charset utf8. Then try this (commits excluded for brevity): create table "Temp" ("Dummy" int); insert into "Temp" ("Dummy") values (1); select * from "Temp"; alter table "Temp" add "New" timestamp default '0001-01-01' not null; select

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Adriano dos Santos Fernandes
On 27/04/2011 19:28, Support List wrote: > I am doing a new major release of IB Objects soon and I want to get > confirmation of some things before I finalize it. > > I have some scenarios that I would like to know what to do about. > There are a total of 9 possible combinations of 3 aspects. > > A

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Geoff Worboys
Adriano dos Santos Fernandes wrote: ... > Data is transliterated from its charset to client charset and > vice-versa. NONE/OCTETS ->> something: data is validated accordingly to something something ->> NONE/OCTETS: nothing is done something1 ->> something2: data is transliterated Hi Adriano, Wh

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2011 08:20, Geoff Worboys wrote: > Adriano dos Santos Fernandes wrote: > ... >> Data is transliterated from its charset to client charset and >> vice-versa. > NONE/OCTETS ->> something: data is validated accordingly to something > something ->> NONE/OCTETS: nothing is done > something1 -

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Geoff Worboys
Adriano dos Santos Fernandes wrote: > On 28/04/2011 08:20, Geoff Worboys wrote: >> ... >> While on this sort of subject are you able to offer any >> information about what happens to API text such as SQL >> statements and the like) sent to the server? (And details >> like relation names etc return

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2011 08:57, Geoff Worboys wrote: > Adriano dos Santos Fernandes wrote: >> On 28/04/2011 08:20, Geoff Worboys wrote: >>> ... >>> While on this sort of subject are you able to offer any >>> information about what happens to API text such as SQL >>> statements and the like) sent to the server

Re: [Firebird-devel] UTF8 Encoding and Decoding

2011-04-28 Thread Geoff Worboys
> Yes. But UNICODE_FSS is currently validated as UTF-8 but in > fact it should not allow 4-bytes characters. So doing it may > result in problems when converting from UNICODE_FSS to UTF-8 > or other character set. > It's better to never use NONE charset, specially for the > connection charset. Ag

[Firebird-devel] Firebird 2.5 on Freebsd 8.2

2011-04-28 Thread Leonardo M . Ramé
Hi, I installed FB 2.5 on FreeBSD 8.2 AMD64, and found that fb_smp_server doesn't start because of the libraries libicu* requiered are version 38 and the server has installed version 46. This is what I get when starting fb_smp_server: martin@server:/home/martin$ sudo /usr/local/sbin/fb_smp_serv

Re: [Firebird-devel] Firebird 2.5 on Freebsd 8.2

2011-04-28 Thread Adriano dos Santos Fernandes
On 28/04/2011 10:22, Leonardo M. Ramé wrote: > Hi, I installed FB 2.5 on FreeBSD 8.2 AMD64, and found that fb_smp_server > doesn't start because of the libraries libicu* requiered are version 38 and > the server has installed version 46. > > This is what I get when starting fb_smp_server: > > mar

Re: [Firebird-devel] Firebird 2.5 on Freebsd 8.2

2011-04-28 Thread Philippe Makowski
Leonardo M. Ramé [2011-04-28 15:22] : > Hi, I installed FB 2.5 on FreeBSD 8.2 AMD64 how did you install it ? you can build it yourself with --with-system-icu build option but with icu 4.6 you need also the patch from http://tracker.firebirdsql.org/browse/CORE-3447 http://firebird.svn.sourceforg

Re: [Firebird-devel] Firebird 2.5 on Freebsd 8.2

2011-04-28 Thread Leonardo M . Ramé
--- On Thu, 4/28/11, Philippe Makowski wrote: > how did you install it ? cd /usr/ports/database/firebird25-server make -DPACKAGE_BUILDING make install > you can build it yourself with --with-system-icu build > option > but with icu 4.6  you need also the patch from > http://tracker.firebirdsql

[Firebird-devel] [FB-Tracker] Created: (CORE-3453) Added not null timestamp col with default causes error on select of old null records

2011-04-28 Thread Kjell Rilbe (JIRA)
Added not null timestamp col with default causes error on select of old null records Key: CORE-3453 URL: http://tracker.firebirdsql.org/browse/CORE-3453 Project: Fir

[Firebird-devel] [FB-Tracker] Reopened: (CORE-3355) Wrong comparsion of DATE and TIMESTAMP if index is used

2011-04-28 Thread Philippe Makowski (JIRA)
[ http://tracker.firebirdsql.org/browse/CORE-3355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philippe Makowski reopened CORE-3355: - seems that it is not fixed in 2.1.4 and in 2.5.0 see : SQL> create table tdate (id integer not

[Firebird-devel] [FB-Tracker] Created: (CORE-3454) "fb_lock_print -c" hangs server

2011-04-28 Thread Alexander Peshkov (JIRA)
"fb_lock_print -c" hangs server --- Key: CORE-3454 URL: http://tracker.firebirdsql.org/browse/CORE-3454 Project: Firebird Core Issue Type: Bug Components: LOCK_PRINT Affects Versions: 2.5.0

[Firebird-devel] [FB-Tracker] Created: (CORE-3455) Slow connect/disconect FB 2.1.4 on Win2003

2011-04-28 Thread rudi f (JIRA)
Slow connect/disconect FB 2.1.4 on Win2003 -- Key: CORE-3455 URL: http://tracker.firebirdsql.org/browse/CORE-3455 Project: Firebird Core Issue Type: Bug Affects Versions: 2.1.4, 2.1.3 Envi