Hi!
I am trying to convert a BLOB (unlimited size, theoretically) to a long
VARCHAR (say, VARCHAR(8192)). This should be easy enough to do:
DECLARE VARIABLE b BLOB; /* input */
DECLARE VARIABLE v VARCHAR(8192); /* output */
...
v = SUBSTRING(b, 1, 8192);
Except that as soon as I convert
trskopo [2011-12-28 03:31] :
from where and how did you get such message ?
what did you did ?
under CentOS 6.2 use EPEL repository, you have Firebird packages inside
http://fedoraproject.org/wiki/EPEL
http://fedoraproject.org/wiki/EPEL/FAQ
su -c 'rpm -Uvh
Em 27/12/2011 22:19, W O escreveu:
Hello everybody
I want to have a Firebird's database in a computer with public IP and than
the users from theirs cell phones Blackberry or Android can to do queries,
like:
- What products we sell today?
What tools do you think will be good for that job?
Josef Kokeš wrote:
I am trying to convert a BLOB (unlimited size, theoretically) to a long
VARCHAR (say, VARCHAR(8192)). This should be easy enough to do:
DECLARE VARIABLE b BLOB; /* input */
Which subtype of BLOB? IIRC, BLOB subtype 1 (text) should support
character sets, so you don't
Dne 28.12.2011 17:21, Milan Babuskov napsal(a):
Josef Kokeš wrote:
I am trying to convert a BLOB (unlimited size, theoretically) to a long
VARCHAR (say, VARCHAR(8192)). This should be easy enough to do:
DECLARE VARIABLE b BLOB; /* input */
Which subtype of BLOB? IIRC, BLOB subtype 1 (text)
Hi
creating all combination of index is not good solution
maybe my tracker request will be good for you
if yes vote on it http://tracker.firebirdsql.org/browse/CORE-2795
but in your scenario will be good also shardering
simple way for simple shardering solution will be divide data between tables