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 <table_name> MODIFY <col_name> VARCHAR(10000) http://stackoverflow.com/questions/1279568/how-can-i-modify-the-size-of-column-in-a-mysql-table 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 <depja...@gmail.com> 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 <prmari...@gmail.com> 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" <prmari...@gmail.com> >> het volgende: >> >>> for that you would have to alter the database schema. >>> >>> On Wed, Feb 25, 2015 at 6:12 AM, Roald <depja...@gmail.com> 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
