sender's 100 chars limit

[Candide Kemmler <ca...@urbanium.tv>]

Hi,

I'm using a mysql repository for the email messages. Sometimes I have to 
remove messages whose sender field uses more than 100 characters as this 
totally prevents James from running...

Is there a workaround. I think even if there is one, this should be 
corrected in future releases.

Candide


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: sender's 100 chars limit

[Serge Knystautas <se...@lokitech.com>]

You can make that SQL field in your database longer if you are experiencing
that problem, although I'm not sure why you're experiencing a problem with
100 characters are the SQL in sqlResources.xml sets it to varchar(200).  Is
maybe mysql or Java storing the addresses as double byte characters?  I've
never noticed a problem with sender length limits.

Serge Knystautas
Loki Technologies - Unstoppable Websites
http://www.lokitech.com/
----- Original Message -----
From: "Candide Kemmler" <ca...@urbanium.tv>
To: <ja...@jakarta.apache.org>
Sent: Friday, November 30, 2001 4:02 AM
Subject: sender's 100 chars limit


> Hi,
>
> I'm using a mysql repository for the email messages. Sometimes I have to
> remove messages whose sender field uses more than 100 characters as this
> totally prevents James from running...
>
> Is there a workaround. I think even if there is one, this should be
> corrected in future releases.
>
> Candide
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: sender's 100 chars limit

[Oki DZ <ok...@pindad.com>]

On Fri, 30 Nov 2001, Candide Kemmler wrote:
> I'm using a mysql repository for the email messages. Sometimes I have to 
> remove messages whose sender field uses more than 100 characters as this 
> totally prevents James from running...

You can make the field length longer:
CREATE TABLE `Message` (
  `message_name` varchar(128) NOT NULL default '',
  `repository_name` varchar(128) NOT NULL default '',
  `message_state` varchar(32) NOT NULL default '',
  `error_message` varchar(200) default NULL,
  `sender` varchar(255) NOT NULL default '',
  `recipients` text NOT NULL,

I defined the sender's length to be 255; if you need more, you can
use "text".

Oki



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>