Tag Info

New answers tagged


If the issue you are having is Truncation you can use this XML approach that gets around most of the issues with XML entitisation. declare @VeryLongText nvarchar(max) = ''; SELECT top 100 @VeryLongText = @VeryLongText + ' ' + OBJECT_DEFINITION(object_id) FROM sys.all_objects WHERE type='P' and is_ms_shipped=1 SELECT LEN(@VeryLongText) SELECT ...


You seem to be thinking of column-based storage systems (or you may come from that background). MySQL (InnoDB, in particular) stores its rows clustered around its primary key, and thay, and any other secondary indexes are stored in B+Tree structures. So, if you store the text in varchar(64) and index it wholly, it will take up to -the storage is in fact ...

Top 50 recent answers are included