[xoops-trackers] [ xoops-Bugs-3534503 ] alter table 'user' user_sig and bio fields to 'text'

[SourceForge.net <no...@so...>]

Bugs item #3534503, was opened at 2012-06-11 21:50
Message generated for change (Comment added) made by irmtfan
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=430840&aid=3534503&group_id=41586

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Core -  Core
Group: XOOPS 2.5.x
Status: Open
Resolution: None
Priority: 7
Private: No
Submitted By: irmtfan (irmtfan)
Assigned to: Nobody/Anonymous (nobody)
Summary: alter table 'user' user_sig and bio fields to 'text'

Initial Comment:
This is not a bug but it is very needed because the limited size of these fields will cause big problems specially in 2-bytes languages.

For example in arabic and persian users just have 255/2=127 characters 

Please change the size to 'text'

ALTER TABLE `users`  MODIFY `user_sig` text;
ALTER TABLE `users`  MODIFY `bio` text;

----------------------------------------------------------------------

>Comment By: irmtfan (irmtfan)
Date: 2012-06-18 23:22

Message:
Also according to this very old tracker:
https://sourceforge.net/tracker/?func=detail&aid=1929837&group_id=41586&atid=430843

online_uname size is still 25 bytes too.
should alter like this:

ALTER TABLE `online` MODIFY `online_uname` varchar(60);

----------------------------------------------------------------------

Comment By: irmtfan (irmtfan)
Date: 2012-06-11 21:57

Message:
Also according to this bug:
https://sourceforge.net/tracker/?func=detail&aid=930397&group_id=41586&atid=430840

the uname field size should be more than 25 bytes.

Now it is just 25 bytes in the new installation.

in install/sql/mysql.structure.sql

should be at least  60 bytes.

ALTER TABLE `users` MODIFY `uname` varchar(60);

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=430840&aid=3534503&group_id=41586