Re: [GENERAL] Overhead changing varchar(2000) to text

2015-12-15 Thread Edson Richter
Em 15/12/2015 00:27, Jim Nasby escreveu: On 12/9/15 5:43 PM, Edson Richter wrote: Actually, the biggest change is that I don't have to keep another constraint between app and database - if I want to increase the user perceived space, now I just have to change the application (of course, under th

Re: [GENERAL] Overhead changing varchar(2000) to text

2015-12-14 Thread Jim Nasby
On 12/9/15 5:43 PM, Edson Richter wrote: Actually, the biggest change is that I don't have to keep another constraint between app and database - if I want to increase the user perceived space, now I just have to change the application (of course, under the limits). For what it's worth, I usuall

Re: [GENERAL] Overhead changing varchar(2000) to text

2015-12-09 Thread Edson Richter
Thanks. After reading, I've run some tests and found no storage changes in tables moving from varchar(2000) to text. Actually, the biggest change is that I don't have to keep another constraint between app and database - if I want to increase the user perceived space, now I just have to change

Re: [GENERAL] Overhead changing varchar(2000) to text

2015-12-09 Thread Kevin Grittner
On Wed, Dec 9, 2015 at 5:17 PM, Kevin Grittner wrote: > On Wed, Dec 9, 2015 at 5:13 PM, Edson Richter > wrote: > >> I do have several tables that uses varchar(2000) as store for remarks. >> Lately, one customer need to store more than 2000 characteres, and I'm >> considering changing from varcha

Re: [GENERAL] Overhead changing varchar(2000) to text

2015-12-09 Thread Kevin Grittner
On Wed, Dec 9, 2015 at 5:13 PM, Edson Richter wrote: > I do have several tables that uses varchar(2000) as store for remarks. > Lately, one customer need to store more than 2000 characteres, and I'm > considering changing from varchar(2000) to text. > > What is the overhead? None -- they are sto

[GENERAL] Overhead changing varchar(2000) to text

2015-12-09 Thread Edson Richter
Hi! I do have several tables that uses varchar(2000) as store for remarks. Lately, one customer need to store more than 2000 characteres, and I'm considering changing from varchar(2000) to text. What is the overhead? Is there any place where I can learn about storage impacto for each data ty