At 03:48 AM 1/15/2008, Alastair Burr wrote:
My questions are firstly, does the use LONG VARCHAR have any effect on the size or performance of the database compared to a (short) VARCHAR?
Alastair, AFAIK, there is no effect on the performance of the database. However, the size of .RB4 file will vary accordingly.
And, secondly, am I right in thinking that I can convert this column to VARCHAR simply by removing the word LONG and adding the required length in brackets to my unload file (and reload it)?
Correct! Similar to the examples below: -- Example 01 SET ERROR MESSAGE 2038 OFF DROP TABLE InvestigationNotes CREATE TABLE `InvestigationNotes` + (`CID` INTEGER, `CNotes` LONG VARCHAR) SET ERROR MESSAGE 2038 ON RETURN -- Example 02 based on example 01 above ALTER TABLE `InvestigationNotes` + ALTER `CNotes` VARCHAR (8000) RETURN -- Example 03: SET ERROR MESSAGE 2038 OFF DROP TABLE BriefNotes CREATE TABLE `BriefNotes` + (`CID` INTEGER, `BNotes` VARCHAR (7000)) SET ERROR MESSAGE 2038 ON RETURN Hope that explains! Very Best R:egards, Razzak.
