Re: [dev] how to change maxlength of a textarea defined in an xml file?

8 Mar 2015


      Roald
Last I had checked in MySQL VARCHAR(255) was the max size. Now it seems
they made a change to VARCHAR to allow for sizes over 255 the new max is
65,535 bytes -2 which equals 65,533 characters.
So yes that should work just fine. Just be aware the larger you make it the
larger and slower your indexes will be so don't go overboard.
This is based on http://dev.mysql.com/doc/refman/5.6/en/char.html
you will need to check the equivalent documentation page for the exact
version you are running to verify if its supported on your version.


On Thu, Feb 26, 2015 at 4:28 AM, Roald  wrote:
...
mysql 5.5 should have a limit of for varchar of 65553 bytes see :
http://dev.mysql.com/doc/refman/5.5/en/char.html
So I could possibly try something like this:
ALTER TABLE  MODIFY  VARCHAR(10000)
http://stackoverflow.com/questions/1279568/how-can-i-modify-the-size-of-colu...
Now I have to find the table_name and col_name where CustomerIDs is stored.
Regards,
Roald
On Thu, Feb 26, 2015 at 6:50 AM, Roald  wrote:
...
Interesting. So if I would switch to postgresql I would Get double The
amount of characters without having to do anything else. 512 characters is
still not enough though.
Would I have to change any code in OTRS if I would change to blob? where
would I find this code?
As far as I understand the field CustomerIDs is created by The xml
definition so I would probably have to find it in a table related to xml
definitions somewhere. Any idea how to find this field?
I will try to make a blob out of it and see what happens.
Thank you very much,
Regards,
Roald
Op 26 feb. 2015 00:42 schreef  het volgende:
Sorry it's been a long time since I dug into the schema. Also be aware if
...
I remember correctly the limitation comes from MySQL. VARCHAR fields in
MySQL max out at 256 characters and PostgreSQL maxes out at 512. This could
in theory be resolved by transforming the column into a "TEXT" field which
is essentially a BLOB containing text, but I don't know how well MySQL with
searches of that field type. I know extensive work was done in PostgreSQL
to make it work well for data warehouses, but I doubt much work was done on
it for MySQL since I last looked.
Sent from my BlackBerry 10 smartphone.
  *From: *Roald
*Sent: *Wednesday, February 25, 2015 13:28
*To: *Development community of OTRS
*Reply To: *Development community of OTRS
*Subject: *Re: [dev] how to change maxlength of a textarea defined in
an xml file?
I had a suspicion that I would need to do something like that.
Would you happen to know how to go about this?
Thank you very much,
With kind regards,
Roald
Op 25 feb. 2015 18:05 schreef "Paul Robert Marino" 
het volgende:
...
for that you would have to alter the database schema.
On Wed, Feb 25, 2015 at 6:12 AM, Roald  wrote:
...
Dear all,
I want to make a small adaption to this CustomerSLA module:
http://opar.perl-services.de/package/D/DI/DIETMARB/CustomerSLA
I would like to increase the amount of accepted characters of the
CustomerIDs field.
Step one is to increase the Cols and Rows in
/opt/otrs/Kernel/Config/Files/CustomerSLA.xml
<ConfigItem Name="SLAPreferences###02_CustomerIDs" Required="0"
Valid="1">
        <Description Translatable="1">List of customer company IDs
for which
this SLA applies.</Description>
        <Group>CustomerSLA</Group>
        <SubGroup>Frontend::SLA::Preferences</SubGroup>
        <Setting>
            <Hash>
                <Item
Key="Module">Kernel::Output::HTML::SLAPreferencesGeneric</Item>
                <Item Key="Label">CustomerIDs</Item>
                <Item Key="Desc">List of customer company IDs for
which this
SLA applies.</Item>
                <Item Key="Block">TextArea</Item>
                <Item Key="Cols">50</Item>
                <Item Key="Rows">3</Item>
                <Item Key="PrefKey">CustomerIDs</Item>
            </Hash>
        </Setting>
    </ConfigItem>
But If I change Cols and Rows the amount of characters when I hit
Submit in
the AdminCustomerSLA window still gets limited to 250 characters. How
do I
increase the max lenght of characters of CustomerIDs ?
Thank you very much,
With kind regards.
Roald
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
_______________________________________________
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev