[Opensim-dev] Item description should be varchar(84) or varchar(64)?

[Tom Mettam]

The generic SQL command to do this is:

|ALTER  TABLE  `tableName`CHANGE  COLUMN  `columnName`  |||`columnName`|  VARCHAR(size);
|

Untitled It won't affect existing data if you are growing the field 
size. If you shrink it will truncate.

Kind regards

Tom

On 31/07/2014 14:13, Ai Austin wrote:
> At 10:03 31/07/2014, Tom Mettam wrote:
>> I believe it should be VARCHAR(127), since object descriptions can be 
>> 127 characters long.
>
>
> Ah thanks Tom ...  prims can actually be varchar(255) according to my 
> schema and I now wonder if the assets "name" field should also be 
> varchar(64), as it is for Openvue grid just now, or something else?
>
> I see that prims and primitems have varchar(255) for both the name and 
> description which seems odd as I would think all these should be the 
> same?
>
> I created a fresh data base for Openvue for a new server setup as 
> recently as May 2013 and loaded content back in then via OARS and IARs 
> rather than a SQL backup. So I wonder how I got the varchar(64) 
> description and if anyone else has the same value?
>
> Does anyone have the SQL skill to know the command which will amend 
> the description field to change its size and advise if that could mess 
> up any existing assets that have a varchar(64) current description?
>
> -- Yuck.  I see that in prims the CreatorID can be varchar(255) 
> presuMably to accommodate HG creators, but that LastOwnerIDis char(36) 
> yet that also of course can be a HG user.  Maybe this shouLd be a 
> mantis issue as there seems to be a check needed at least?
>
>
>
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20140731/83e49d0b/attachment.html>