Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Varchar takes more diskspace than Character Type ?
Message
From
10/09/2008 11:06:40
 
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:
01346358
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

Oh ok. If Sergey say so that is it then :).
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Reply
Map
View

Click here to load this message in the networking platform