Hello When I call *_isc_attach_database* from *fbembed.dll* 2.1.1 I get this error saying 'Unavailable database'. I can open the same database with *isql.exe*...
Timothy Madden
terminatorul@...
Sep 1, 2008 7:45 am
96636
... Depends whether you include MySQL in 'databases' ;) -- Milan Babuskov http://www.flamerobin.org http://www.guacosoft.com...
... Embedded is a deployment model. Both the server and the client are running in (the same) application space. When one application has a database open...
... I should have said "In databases that are concerned about consistency, if there is a race between consistency and usefulness, consistency always wins."...
... Ok, we're getting somewhere now. The problem you have looks very similar to various NAT-related network problems. After a period of inactivity, some of the...
... error ... [...] ... in (the same) application space. When one application >has a database open within this space, other applications are blocked from...
Timothy Madden
terminatorul@...
Sep 1, 2008 8:52 am
96641
... I appologize about off topic, but after two years of not working with above mentioned 'database' I can still remember the pain of its usefulness... ;) ...
Hi, In a databse with default charset UTF8 I have a couple of char(1) and char(2) columns. I know these are implemented as char(4) and char(8) behind the...
... I can confirm the behaviour. It's interesting that reported column size by IBPP is 4 and 8 respectively. IBPP uses a code like this: XSQLVAR* var =...
... Nor I am. But this requires API change or change on how things are described to the client. Basically, we need that CHAR datatype be described with a...
... ISQL is also problematic with UTF-8, and also requires FB API changes. It tries to pad columns thinking on bytes. We need that server send "number of...
... [snip] ... So, unless you are willing to do a client-breaking change to the API, it is up to the clients to strip the returned data in char(n) columns down...
... Why ? You are talking about CHAR datatype, i.e. fixed number of characters. For UTF8 you can simply compute number of characters = buffer length / 4 Is it...
... Not sure to whom you're talking Ivan. I was told by Adriano that to be able to tell the client the actual data length it would require a new SQL_TYPE....
Hi all, within other DBs one can use aggregate functions without the group by clause. This is mostly achieved with the "over( ... )" statement like this ...
klaus_winter@...
Sep 1, 2008 12:13 pm
96650
... Firebird doesn't support that syntax. The feature has been requested in the tracker though. Sasha...
Hi group, I am converting an existing MySQL database application (very old version of MySQL) to FB 2.x. I writing the code to emulate the calls made to the...
Norman McFarlane
norman@...
Sep 1, 2008 1:14 pm
96653
... If we have '<char that use 2 bytes>' in a CHAR(3) UTF-8 column, engine will return a buffer with '<2 bytes><10 spaces>'. We know that valid bytes of this...
... Solution with versioning is possible, but we have more things to change, for example strings of variable lengths (for system functions parameters/return)....
... An intermediate driver like IBPP could indeed deduce the codepoint size from the physical size by divided by 4, assuming it knows at the point in the code...
... No ... No. In real SQL the boot is really on the other foot. It doesn't treat a string as anything but a string unless you "do something" to make it...
... I don't know about the technicalities of course, but it seems to me that the most logical thing would be for the engine itself to know about the used...
... It is a FlameRobin bug, because client application has enough informations to be able to display data correctly. ... VARCHAR is sent to the client in fixed...
Ivan, ... I fear I don't agree with you, unless you prove me wrong. Does the XSQLDA/XSQLVAR give all the needed information to fully describe these details...
... I perfectly agree with you that finding the number of characters (not byte-length) is needed. But why would the engine return description of its output if...
"Sasha Matijasic" escribió ... Hi Sasha! I'm very sorry I didn't explain myself better when I posted this thread... I do use the IBX components and also the...
I need to upgrade several databases (1.5 & 2.0) to 2.1 in the near future. I was planning on doing the standard "backup with old version, upgrade, restore with...
Olivier, ... After prepare, the xsqlda structure contains * datatype (CHAR) * character set (UTF8) * desired buffer length IMO it is sufficient to get correct...
... you mean in all your triggers and SPs? If so, I would register 2 copies of the DB in your favourite admin tool (source and target). Do a search and replace...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
