Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Varchar takes more diskspace than Character Type ?
Message
 
 
To
10/09/2008 10:56:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01346349
Message ID:
01346352
Views:
9
>Dear All
>
>Somehow did not sound right to me but it is infact happening.
>
>Changed one large column (240 chars) from Character to Varchar and size on disc actually increased ???
>I was actually expecting some optimisation with disc space but got actually opossite from what I expected
>Difference is very small but still ...
>
>Is varchar introduced only for better compatibility with remote data or there is some other practical use to
>varchar fields versus old fashion character type columns ?
>
>TIA

Check this recent thread Re: Saving space with Varchar Thread #1345228 Message #1345231
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform