Archiving

Hi All,
I'm building an archiving applicaition for my small organization, but I have many file types such as videos, photos, texts, pdfs... and some huge file sizes of about 500 MB.
My questions are:
1. Somefriend told me that there is a hardware compression device which can compress allready compressed videos and JPEGs. Is it correct? If so, where can I surf to find such devices?
2. Which datatype have I to use with SQL Server 2000 to handle all the different file types and sizes?

Thanks very much
HaythamAny answer there?|||1. I'd be surprised if such a thing exists. Ask your friend to be more specific.

2. I'd guess binary or varbinary. I have no experience storing binaries in sql-server though.|||Store raw datafiles as text or image datatypes.

Arabic FTS

I am storing Arabic texts with "Erab" (Erab is used with Arabic alphabets
above or beneath the letter to show how the letter must be read) . But the
user might not enter Erab for the search. Is it possible to ask fulltext
indexes to ignore Erab?!
Any help would be greatly appreciated.
Leila
Could you possible post one of these documents here, or send it to me
offline?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:O6UyeCM8FHA.740@.TK2MSFTNGP11.phx.gbl...
>I am storing Arabic texts with "Erab" (Erab is used with Arabic alphabets
> above or beneath the letter to show how the letter must be read) . But the
> user might not enter Erab for the search. Is it possible to ask fulltext
> indexes to ignore Erab?!
> Any help would be greatly appreciated.
> Leila
>
|||Hi Hilary,
I send two words:
These words are not equal in FTS.
Thanks,
Leila
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:#pFxE0b8FHA.1280@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Could you possible post one of these documents here, or send it to me
> offline?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:O6UyeCM8FHA.740@.TK2MSFTNGP11.phx.gbl...
the
>
|||Sorry Leila, but these will be recognized as different characters. Try to
FreeText search, this might yield better results, but you might have to use
the Thesaurus option.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23aPtV438FHA.3804@.TK2MSFTNGP14.phx.gbl...
> Hi Hilary,
> I send two words:
>
>
> These words are not equal in FTS.
> Thanks,
> Leila
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:#pFxE0b8FHA.1280@.TK2MSFTNGP10.phx.gbl...
> the
>