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
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
_______________________________________________
Opensim-dev mailing list
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
