Thanks for the info! I solved my issue in another way.
Regards,
Roald
On Sun, Mar 8, 2015 at 10:31 PM, Paul Robert Marino prmari...@gmail.com
wrote:
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
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
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(1)
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
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.
A better (more specific question) to ask is. Which database field has to be
changed or how can I find this out?
Regards,
Roald
Op 25 feb. 2015 19:28 schreef Roald depja...@gmail.com het volgende:
I had a suspicion that I would need to do something like that.
Would you happen to know how to go
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
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
