Board index MS SQL Server

File Extension column size

File Extension column size

Post by Peruri Srinivasul » Sat, 20 Jul 2002 04:45:11



Hi Group,
To enable the full-text search on image columns, what should be the size of
the  file extension column.
Do we have to store   .doc  , i.e  'dot'doc or just doc
 
 
 
Top

File Extension column size

Post by John Kan » Sat, 20 Jul 2002 10:48:38


Peruri,
You should use char(3) or char(4) or varchar(3) or varchar(4) or sysname. If
the datatype for the file extension is larger, for example varchar(10), the
MS Search engine will not recognize it correctly and will not FT Index those
documents.

Regards,
John


Quote:> Hi Group,
> To enable the full-text search on image columns, what should be the size
of
> the  file extension column.
> Do we have to store   .doc  , i.e  'dot'doc or just doc


 
 
 
Top

1. SQL Server database file size versus Oracle File size

We are migrating from Oracle to SQL Server and found that
after all optimization and shrinking data files, SQL
Server files are still twice as big as Oracle database
files. Is there any solution for this to have optimal file
size on SQL Server. As our existing product uses a large
oracle database 20Gb in size that we package and deliver
to the customers, now with SQL Server this is going to be
40GB. Any suggestions will be helpful.

Thanks

-Alfred

2. pgsql-server/src/backend/utils/misc check_guc

3. Backup file file extensions

4. Correction - Call for Papers - Visual Data Exploration and Analysis V

5. File extension on saving a file in .NET

6. System Menu display problem????? Help me please :)

7. Find out file extension from file name.

8. snaoledb

9. SS7 back up file file extensions

10. Adding new column into Access increases the size of the file

11. Table size estimates and column sizes

12. Changing a column size when column is PK

13. alternate column names or column size through sql-create-table


All times are UTC
Board index