Re: Regarding varchar

Hi prateek, The VARCHAR data type stores character strings of varying length that contain single byte and ( if the locale supports them) multibyte characters, where m is the maximum size(in bytes) of the column and r is the minimum number of bytes reserved for that column. Here, you can store character strings that are less than m, but not longer than value of m that has been specified. Also, specification of r is optional and can be any value between 0 to 255, but must be less than the value of m, that has been specified. If r is not mentioned, it defaults to zero. A column declared as VARCHAR without parameters has a maximum size of one byte and is reserved a size of zero. So, when you specify VARCHAR(100,1 ), the row size amounts to 101 bytes. Precisely, 100 is the maximum number of bytes of the column and 1 is the minimum number of byte reserved for that column. For VARCHAR, this 1 byte is allocated to specify the size of the column and other such info .... Regards, Prasanna "Prateek Jain" <prateekvjain@gma il.com> To Sent by: informix-list@iiug.org informix-list-bou cc nces@iiug.org Subject Regarding varchar 22/08/2006 16:04 Hello everybody, I have one table in which varchar is declared as varchar(100,1) whats the significance of 1 in the above varchar(). any idea. -- Regards, Prateek Jain _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list