RE: DBD::MaxDB and Unicode-Data

2005-09-20 Thread Alexey Gaidukov
diff -uNr DBD-MaxDB-7.5.00.32.origin/dbdimp.c DBD-MaxDB-7.5.00.32/dbdimp.c --- DBD-MaxDB-7.5.00.32.origin/dbdimp.c 2005-09-12 15:26:20.0 +0900 +++ DBD-MaxDB-7.5.00.32/dbdimp.c2005-09-21 11:08:12.0 +0900 @@ -222,6 +222,7 @@ DBD_ERR_VALUE_OVERFLOW_D, DBD_ERR_PARAMET

Endless-loop in SQLDBC_RowSet_fetch for LONG UNICODE in case of encoding=UTF8

2005-09-20 Thread Alexey Gaidukov
SQLDBC_Connection_connectNTS(imp_dbh->m_connection, host, dbname, user, password, SQLDBC_StringEncodingType

Re: How to track DB usage of user

2005-09-20 Thread Robert Klemme
2005/9/20, Jens-Peter C. Hillers <[EMAIL PROTECTED]>: > > May be true for 32, but for 2000 ?? > so take the middle ! were talking about 64K. I'll think some Megabytes are > your Problem ! > or use select count(*)*avg(length(YourVarcharField)) from t1 select sum(length(YourVarcharField)) from t1 wh

AW: AW: [FSID] How to drop a public function?

2005-09-20 Thread Anhaus, Thomas
Andreas Goldstein wrote : >> --- Ursprüngliche Nachricht --- >> Von: "Anhaus, Thomas" <[EMAIL PROTECTED]> >> An: "Andreas Goldstein" <[EMAIL PROTECTED]>, >> >> Betreff: AW: [FSID] How to drop a public function? >> Datum: Tue, 20 Sep 2005 10:50:16 +0200 >> >> Andreas Goldstein wrote : >> >> > >>

AW: How to track DB usage of user

2005-09-20 Thread Jens-Peter C. Hillers
> -Ursprüngliche Nachricht- > Von: Zabach, Elke [mailto:[EMAIL PROTECTED] > Gesendet am: Dienstag, 20. September 2005 16:09 > An: [EMAIL PROTECTED]; Ralf Schneider; maxdb@lists.mysql.com > Betreff: AW: How to track DB usage of user > > Jens-Peter C. Hillers wrote: > > > > Hi, > > > > I thin

AW: How to track DB usage of user

2005-09-20 Thread Zabach, Elke
Jens-Peter C. Hillers wrote: > > Hi, > > I think the "normal" tables could be estimated. > > row by size (varchar (32) = 32) will result in a good guess > May be true for 32, but for 2000 ?? > BUT > > the problem will be that there is NO way of evaluating the size og a blob > (long ascii or

Re: DBA Password Change (Resend)[FIXED]

2005-09-20 Thread Rob See
All, Just incase someone else runs into this problem in the future, I believe I figured out what the problem was. I continued to get the error until I did a load_systab. I thought I had done that after the last upgrade but maybe I didn't. I was able to change the password after that. Thanks

Re: AW: [FSID] How to drop a public function?

2005-09-20 Thread Andreas Goldstein
> --- Ursprüngliche Nachricht --- > Von: "Anhaus, Thomas" <[EMAIL PROTECTED]> > An: "Andreas Goldstein" <[EMAIL PROTECTED]>, > > Betreff: AW: [FSID] How to drop a public function? > Datum: Tue, 20 Sep 2005 10:50:16 +0200 > > Andreas Goldstein wrote : > > > > >Hi Listmembers, > > > >I defined a p

AW: AW: How to track DB usage of user

2005-09-20 Thread Jens-Peter C. Hillers
Hi, I think the "normal" tables could be estimated. row by size (varchar (32) = 32) will result in a good guess BUT the problem will be that there is NO way of evaluating the size og a blob (long ascii or long byte) in a SQL Statement like select sum(datalen(MYBLOB)) from T1 regrads jph P.S

Re: AW: How to track DB usage of user

2005-09-20 Thread Ralf Schneider
Am Dienstag, 20. September 2005 14:58 schrieb Robert Klemme: > Then probably a limit different from bytes makes more sense? Maybe > something that can be directly translated into record counts (max > contacts or similar). That's right from a developers perspective, but not from a sales perspectiv

Re: AW: How to track DB usage of user

2005-09-20 Thread Robert Klemme
Then probably a limit different from bytes makes more sense? Maybe something that can be directly translated into record counts (max contacts or similar). Btw, Elke ad 2: I simply picked a bad name, as the "user" really should be the name of the column that stores the user name or user id. My ba

Re: AW: How to track DB usage of user

2005-09-20 Thread Ralf Schneider
Am Dienstag, 20. September 2005 13:44 schrieb Zabach, Elke: > 5. The szenario that different people have to share one table, but are > limited to some amount of space, seems to me uncommon. May I ask for > some background-info? > I think that info stored in a table used by different people is reall

RE: ireport in 7.6 releases

2005-09-20 Thread Dittmar, Daniel
>I was used to ireport, for sql queries, with the 7.5 maxdb releases. > >Is ireport deprecated in 7.6 release (7.6.00.12) ? Basically yes, sqlcli should be used instead. So ireport won't get any new features and will probably be removed later on. Of course, you can still use your copy, as the unde

AW: How to track DB usage of user

2005-09-20 Thread Zabach, Elke
Ralf Schneider wrote: > > Am Montag, 19. September 2005 17:28 schrieb Robert Klemme: > > You could do reports like > > > > select user, count(*) > > from your_table > > > > to see which user takes up how much space of the table. If you > > combine this with information about the whole table's siz

AW: [FSID] How to drop a public function?

2005-09-20 Thread Anhaus, Thomas
Andreas Goldstein wrote : > >Hi Listmembers, > >I defined a public function on my 7.6.00.12-Windows MaxDB. Now >I would lik >to change the function, but I can not drop the old version :( > > > >Here is what I did in more detail: > >Logged into the DB-instance as DBAdmin >CREATE PUBLIC FUNCTION KD