none
Full Text Index

    Question

  • Hi,

    I am new to full text indexes and i was trying to setup it on my local system.Everything went fine till i ran select statement on created index.It is not giving any result.

    Script that i used to configure is below.

    1.Created the table

    CREATE TABLE SQLServerDocuments (ID INT IDENTITY(1,1) PRIMARY KEY, DocType VARCHAR(6), DOC VARBINARY(MAX))

    2.Inserted the data into table from docx file .

    DECLARE @worddoc VARBINARY(MAX)
    SELECT @worddoc = CAST(bulkcolumn AS VARBINARY(MAX))
    FROM OPENROWSET( BULK 'C:\Users\Sourabh Tiwari\Desktop\Create\High Availability with SQL Server 2008.docx', SINGLE_BLOB ) AS x
    INSERT INTO SQLServerDocuments (DocType,DOC)
    VALUES ('doc',@worddoc)
    GO

    3.Created the catalog for the full text index.

    CREATE FULLTEXT CATALOG WhitePaperCatalog AS DEFAULT

    4.Created the stoplist

    CREATE FULLTEXT STOPLIST WhitePaperStopList FROM SYSTEM STOPLIST;

    ALTER FULLTEXT STOPLIST WhitePaperStopList ADD 'Downtime' LANGUAGE 1033;

    5. Created the full text index on table.

    CREATE FULLTEXT INDEX ON dbo.SQLServerDocuments
    (
    DOC
    TYPE COLUMN DocType
    )
    KEY INDEX PK__SQLServe__3214EC27B4967676
    ON WhitePaperCatalog
    WITH STOPLIST = WhitePaperStopList;
    GO

    6.Select statement.

    SELECT
    DOC, DocType
    FROM SQLServerDocuments
    WHERE CONTAINS(DOC, 'replication')

    Result:

    (0 rows affected)

    After that i made a change, earlier i was using docx file so i started it again from scratch and used a doc file instead and this time the output was different . 

    Doc column gave --0xD0CF11E0A1B11AE10000000000000000000000000000000021000300FEFF0900060000000000000000000000080000007A03000000000000001000007903000001000000FEFFFFFF000000007C0300007D0300007E0300007F03000080030000810300008203000083030000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFEF24000044006400000000000000080000000000000000000000000045156504E803E80300000000000000000000000000000000000000000000000000000000000000000F0004F094000000B2040AF00800000001040000000A0000A3000BF0700000007F0080008000044101000000BF0102001200FF010000080080831600000081831E000000840300000000850300000000860300000000870300000000500069006300740075007200650020003100300000006C006F0067006F002D00730071006C00300038002E006700690066000000000010F00400000000000080620007F00724000006063029BA5BE2CE4D05BABAE0BFD211FC0CFF00E3230000010000004400000000000000006E1EF0DB2300003029BA5BE2CE4D05BABAE0BFD211FC0CFF89504E470D0A1A0A0000000D494844520000016B0000004B0806000000B69DA6FA000000017352474200AECE1CE90000000467414D410000B18F0BFC6105000000097048597300000EC300000EC301C76FA8640000235F49444154785EEDDD4FCC7D475DC7F11F1B13576CEAC20D2E481A302E34312448E2CE682024262C488C266E58E84213E2C24577C4540D4612B07461311485A60182C5A68694BF62102A85B416CB9FD202427F054A5B5AFAA3147A7D5ED3F93ECCFD3E73CE3DF7FEEE7DFEB4F34926CF3D73E6CC393367E63DDFF39D39E7B9745A7AFAE9A757DFFABF6FAF1EFDC10F56356A68686868E83CE8D9677FBAFACEC30FAFBEF0C57B569FBFFBEED557BFF6F5D53DF7FECF80F5D0D0D0D079D0638F3D56A0FCA94FFDC7EA7377FD7701F633CFFCA440FABEFBBEB47AF2C92707B087868686CE4ADFFCE6B70AA06FBFFD8E62497FFFFBDF3F0165D6357748DD1C1A1A1A1A3A0DB1981FF8FA83AB3BFEFD23ABDB3EFC6FC5E5F1D4534F4DC2F891471E59B1AE9F7BEEB901ECA1A1A1A1D31048DFFA81DB5637DEF49ED5BB6EBE65F5BFF7DF5F403D07E22B3FFE71B1BAE7803E34343434B407F139B3A4DF76C33FAE6E7EEFFB4BF8D8C73F51C2473EFAFCDF4FFFE7678A05CD35F2C4134FAC40DA84239083FC37BEF18D01EBA1A1A1A143097C59D1400DD8DC20FCD020CD5A06F2071F7AA858D9261959D1261905F00669B0F61BC06BB64343434343FBD273CF3EBBBAF74FFF620DD475D72560665167004B638D35885B25F29DCB8F14B8DFFFE5AFACBEFBBDEF0D580F0D0D0D1D4277FDE19FAC3EFCAAD7ADBE7CE3BB57CF3EFAF3175C80DC4A10EE8FA9A579F1620CEBDA5F16780BFCA1A1A1A1A13DE999872FAF3EF79ADF5DDDFA0B2F2BD006EFFBAFFBABD5C3777E6AF5D483DF2CB0E6FAE0A7AE8714EBDA5AEBFBBFF9AD6259F35D0BDC21C3BA1E1A1A1A3A905A607FFCDA5795DF77FDE23525D8FED8EFFDC1F300BFED8ED563F7DCB7BAF7939F5E7DE9AEBB0BCC6B1645977FF4A3320109DC356A68686868689F0A6083F3A3B77E60F5F8A73FB3FACE5BFE7A75F72FBD6CF5E55FFDF56378DB96E681D7BFA1F8BB41FCBBEF7ACFEAC7777FA1C0FBF2E34FAC1E7FF6D901EB0B224F4D37DF7C737161D5A8A1A1A1F3AE9FFDF0C9E2060165B01607CAE00DE6FE82B3380007EE8078805CBCFD0171F9FCF4BEFBD6FCE1E7492656DFF18E776CFCC68989D6F7DD72CBEAC61B6F5C7DFBDBCFBFB169B5CCAB5FFDEAD51BDFF8C60BB7CE9C2BEBCD6F7EF3EA252F79C9EA9A6BAE595D7FFDF517EAFA87865EF47AEECA95026CE065297FEF6FFFAEC0B7EE3E96F5D53F7DE8C1D5537FFC4725EDD77EE5E5CF83FA55AF5903F814C459E235AB33D56B5FFBDA022C7FE75EFEE1BB974EB8F3CE3B4B3A5F1C04BA6BAFBDB6AC8C29092F887C4240590C34CA6369A6786E2C03D858863934740164254858CF576EBFBDFC05E6BABB28400DCED27CFFEDFF50B659D0F6B1A8C5FDF0CFFFACA401F30C70EE14038374E07D16D677C05AE012A8D127F4A637BDE904ACC94A988B38A9CA925616EBE36B5491721A7CDA4FDFB2C2B94AEC73DCF8D2E2D0D03912B707C882B6BF2CECBAEB127708F88AE7E21007B6A0EEB89228898B451AF900750BEE08E0CD0FFE8D7F79DEED520F3DA85A58B3326BF49AAC72B19F152DB4B09E93A58D56CDCC59A956D9648B5E7A4B211D5FA34E283E573B973777CDD4F7C603D6F9CD5375A08CED2431F70F50739B087EFB264CDD3D343474D6026200BEFCD2971668B3B8C1D6368B19806BD20263006765D7A835D9CF828E01A0F8BE8F7E033F40172BFB08D856A4C4AA1456B72584ED79F62DB06649FA0B52E10E680550F6815486B5E3AEBBEEBAB563BEF295AF16F04B1BE1AD7FFFF692C6C7B1F8B9B921220D9FB97DE01BE788204DBE26E95D73A469FDCDAC60DBEDFE389FFDCE615B7C0C40B659CE718C78BF054F1BFCF4016C415E1FFCE007D7AE696868E88CC5BF0CCE975FF1CAD5D3BFFFBA6350D7DDC7E2EB7EF2377E6D75E59D37ACEDE3DA0069C7837958E8200DD6255115D70988C732C208D67FDFFB37379C582AB80F812D5881284865F0B220010C34014D9A16D6B6E55137CBF7BD414E3CB001A76323DF9B6EBA690D92D2001F5F713ECE5FDBE2ED773C688A736CA411EC630D3B57BB3F061A71CAC8921767BF38D7EE7865F237AE413EB6BFF6C00365A009582B87B41FFAD7DB8ECB3C3434740E04C2577EE7B79F07F65100EC9E6F99D56D5F80DCA3FD33B7BCAF40DA71FCD9ADDFDB368BBA6EAE89251DE06661B7D6B663F6E922012B806291FA0D6CADEB00A8C0CBDB9C01CA16D601F2BA79EC56C9308B09C8003E58B62F1A01A178E7A8514501F7807DE4DFBA2FE23BE3A06F9FBC5A37064BDF752A67AC5A8972C5CA9690B2485B378B5CB378DF83711DF26FAF7D6868E89CA840B7C25A604183B2F8F059130017281FC5F91B69B36B04B4B93C58ED356A565EC6F1624E6B6DB3B4F7312119B0F63BAC6B8FFDB601C93E60B51DE09C82352BD4FE16DE5901EB707D10BFB37CE23CAD0C22AE21AE9155EC787FC3DA0E05F0A75C39F6B946DBAC6EDB798231609D57B7187CD48BEBEFFD138AA1A1A1732096EE132FFBE56E006360FEC9DBDE5A2CF0A77FEB374B9C7D3FBEEE2FBB40E51631C9D8823EAB58E64716B46F96B0A633AC05EE113EED7AC84E0A58B3447D03A5056358AA61ED6E82752C8703C2B2B3A3C8C3C050A3CA276AC5016A8D3A5658FCF6DB6609870BC3753A9734F68917D78329D03A26AE7D5B580F0D0D5D1001321003E8B39FFCC4EA99EBDF52DC1E4FBEF2E5270250FFE4DDFFD4EDECC0CF3552262CAF5C594B03ECDC1FDE9C6C5F7F076A2B44C22DE2375007B4C5E7BC962A601D2B2FC23D00D4197E4B619DFDDEAD220F6B996B5479B9461CCBB8461D8BD5ED3A9CA74695F4E0EBDADAE3E27A7B2B3558F2D27265D81EB01E1A7A810A7C81B85D99C14FCD3A6641B3A64BA8C066658BCFD6B30948EE112E14DBF200FF588F7DBC94CF4A90DBEE389E540472A00666DBAE832B24802DFD2E6E910C6B6BA6C12A40D85AC99B60CD376C3F68B63EE3563D5887AB435ED9176CF58678D759A38E156F50DAEFFAC3D5D15E5FC8F1D205C837C17A6ED9E0D0D0D03916A0827006A2B5D32C6C567709F577405B00627E6A567999703C0AF2E30EB134109CB94558DB5689E473B09AC30D925784B0C4C3CAF677DB152319D6C4320632D06A27E036C19AC26F2C0F6BA54D56B2667D1BDCFE1EAC292C5FC7F32BB36CADEF96779BDEF19FF9AFCF967CDB65785C295E569156792CB98B3401E6D6CD32076BF1AED713C580F6D0D005130B39DC2035EAD24F3FF48112C74502C8ACE962691F01BC58DB15D6E1DB06F2324959578808AC69CBF91C53B33D21D63418F35FD7A835813BCB3A80BD8D851DAE83164A26E8002BBB257AA0CDB066B91A00A493AFD0E61579C4BAE7108B3A402FCF80B0ED58A34D6DDEB1BFB5FEF9D723BE3DBFE35AF7480C4819D6B1E225AEC16BF675D7D0D0D04550C03A40C82D621B94B924C01AB45BDFF1B18BA4023B002D00B755229BC0CA1502C27CD85C2635FA844C4806D459E173695B5992C752CE6E0BF1D9F7EBCB747CD96DBC8942966EDD2CE267960E1059B3AC6616AE7DBD3C5A1908E23810CEAFC03B1EBCED97CE75D65DC732D8B469ACE48849C89034E2B3DB453DBA8638FFD41B90434343E754C0CB720657A0F6DB0A90E2B77EE8C1E3ED9ABCC83EBEE9581D12C09E9B806CE5DBD9DC2382DF357A56AC6FC09E5AC33D343434F48256C09AA5EC6F4C1092DFE2A4B1CDBA2E2E12AB459A49C7F06587756D4549C9A0238342AC0859BA1E3B64B588E358E5356A686868E8C5A19FDDF5D902DB705FD4E80266EE0F10B76DE2D036784BCB3D122B45C03CA01FC0B64CAF64D48845CE076DE2B1B77F4E5C32401F3EEC5D5F51F7C20917033707FFB2E03797897F0E3CF701A55DC4BDD13B9FB817E23F06D854BF53AB698686863688F51C3EEA1A5504DCA06C3F4B19884B78E70DC53D12B06EDD1E802A9F0076FB453F0268A0EEB932F8541D6FA2D30B3196EFC54B33261723D816B6796986FFD60460AC108989BA1CEC33F9664270EEB3AA73027B6092474C72F6CE272ECEC7FF9C2704B791E3952DC2697FDF43FD5A1FBE4DFDC61B974343430B05AE600DC4B1142FAC6AB08E00D8F63906B07B800F01BC8F3B01B6257BE2C01FA8633D35285B9E172FC50070FE5E0838B3A4811B9C1D13139DE0EEEF26995403891E3CE642BB12648940DA8A0B30EAE5B72438E717BE78CF56E725906CF36957991C5A5E533F8DFA1D1A7A518B251B6E8DB09C413ADE621400B95D7EC71D02D4D239BE469F90632CDF6BFFD181C0BAB6EEBA05730460369108CCFBF8121F8BB3078A25611B9858819181B96B6095B6DF1759A27CEE6D8FDF555696B4E7DD260C580F0D6DA1E309C4238B99EF3A7CD2016D906D97CA4917100F2B7B4AFCCB5E8E296F2D760258079CAD089903FF2E8AD7CB7300C37814071B0138C4B58FEF4B61C2E5316759DA07A69BCE9783F47959DE94CE02D65303619437CA2AD8DEB57E87865EF4E24608CBD9B609C216D62796EB5DB9B2F6824C8D5E13807391C827FEB941C0D9361F74FCB3DD70671C42FCCD3D1002C7942FDAC4977DD6203B76094CBC0D38055CC79B589BFBD760FCD47CBD53AE13C05E322177DAB036813855BF26116BB23529477C8A7569FD0E0D0D1DA9BC665E5772C4246309D57216C2DA05F69864745CC9E048F69755204780B6AF7D41A6FC7BB0D7BFA1B83DB84436BD24B34F815C0649FB36E026791DDC0B2E75B32BA0ED018B65E9D8A53E75F24AF994A5BAE4BA4F13D6CA95CF27E4EF75CF49DD6DAADFA1A1A123716D802B0BB89D60F4973BC45AEA16CCF1B28C7DB6FD657903FADA1B8CAF7865B1BEC17F939BE450B232214374DF569C0F2DF580C542F6D1A79A6C6BB5AF9447B09DDFA4CC3A4D58FBE708EDB9048363DD3D3434B44F812FB896175AAA2B04A841DA7E2E0AF1D2013350FB6D3FC0C7CB3040ED38C7736DB4DF17392B79D4CE30E18EA8BBF7A2F80E481B58D42CF29A6467C5F7A9DB601098B3D44F13D67CF4EDB984F83CEBD0D0D01EC5E20DD0967F2C70FBEDCFAF974E3E6A6E0F6006EDB0BAE338F1D287A56D22EC693EF02D1EFD0F257EE40C937D4034E4C350BD09457EDC9AE4AAE54920E73FE736384D58CBBB3D9730BE333234B467717F802F7705D0725700700B6A56B57DC582F686222BFAE8AFE300BC673DB3FAB81FE2FF009EA57A96DFAE2FB8F4D4B37C4DACD5DD7B51CF1F0EC853AB43CE1AD6A7F126A609CA783BD23DE0CBF784633B3EA6B554F25297426F02D7E063BDBBB72F3D3598246E8F895093EFA4363F6BF437CD7148C705C518710FA2FCBE9EA8FCDBCC916C2ABF4FE8EA33CAEF6FFB1F8AF42FF32BCE3D57EFF2D52EB8F65C6B04DBEDFF195D224B63A3CC9147FED7779B248F683791874F1DD7DD1BC548E38EB4CA2CF250075313EA572D937DE59BD38FFEA04C0A16EBBABE81C8E2F61B940BA08F028B3A5C1C2E56D0B0F20D0E589B28AB5167A69E1B645FF0D2B8331841755B582C519E24759EA986719AB066E1B7E712BC185377EF5DDA9A8E95CBD80675E36964C99B9BE026AF0806DAF88C2E2801517E72B2ADB3BB27EDB13A6BC9744B016E9B8F6B9FFA5AA3F2AB5FE9DA6BCA411EED277EA7644EA53DB732E9BBF619A462B54E9B37379CFDE0ED3C8E516FD2F680A78D6CBA5EC74F953904F6B91F44708D80D91B6C5A795376531E35E9A40C50532BB604F96F2ACB56F226A1151ADC1E260141DB6FAB39CAABE3D5C5116E0EFB58D1E54DC3238B1C90050DDBCD6DAD818075DCF4B39406D76B6CAEB726D9593A6CCEDB8DAABBF7AA6DA0983BC62161AD03B5E712A233EF5BBBBC6C0402734643AED7681B403D752EB03620E7FD8EDDE56932C343BEBDF6E99F4EEC527E4645CDE28458876D7AED597DB5FF033407E5073D839310C056974056B32ED6675B36D76EA035407A5209AB3CFA90F34DB9D018263168463EAC7C4F526D1E7ED7434EC8C0D4E6E17A1973F20069F19BF2D0E7229DB229435C074B3DF25796BDFCCB3C96B175CEA06C391D50B39841395672707588CB6BA83522151A6026A39946EA26FBDDC2BA4D7716723D1A535470048DB826D9592CB79CEFBE272F43EA72E9C0903BF42161AD7E7B00996BF0BB882B283A422FE4BA6983EB9B1A9C7BB0D6BE7B6D2682EB0040C068E35D834E5BB35E24F327F9DA7B8330A8CC957F2E28CB94C5999F3C9D03A87BF7348234064ED729A833B063C9B7B036902B9BBCDCBF1A7D42D2C5C0D0EB97ED6AABA97E6BD0897A744F6BF4B1DCFF368F5E7D1844228FDE538901C63E697AE7202EB24DD7BA585EDB066ADF8E6659C70B2A0169F0F6A6E1D477A54123C33AA401AB58413A23CB5423394DE9402A2F07B0BB9AD1AF1D8D058D58C3ABBBF7AE68D0116CD75D6BCA1DED90B0A6DEA02568ACE152B81AB1287BA0527E961D40E868064AF724C34F981A3C32ACD59DFA6AE39C4759B417BF5D8B3EA08DE7EBDA76906A2D35417EF94900247A6572ADACB95CFE5E5D89AFD9ADA9076B6568E3DAF2DB2FE8D7AE5D1C7788FD42FBEFF1B8440C6873967D28602BB479500C8ACA3B35E892B610D75BA38E15FBE431C7A4B8F7BD73C500BEA93FC5FD524FB92C8B05D4BE1D1D6F1146006D5676FCE35A3EECCB3FFA51773507B8097316B30E2A8DC67C1E604D19AC1154A8C656936D250DB5CDABD748F6299DA13D9F065177AD49436BD31D1AD694AF2D823AD9D6DA6CA5C3C823E7AB4C53103060E63A5057A05F931CAB67596B137EFBCB9FDC9EC7F5005C0035B701C7CC01252B5F6786BD3E94CBAF2CCA3FD5B74CB6F5CAEFBA6B926365584B27F83D577E7102901A305CCFD54EAEC535B7FDB1BDFF9B1606B4695D778DBE8455110FA435BA2B658AFBDFBECF8069E2D5CD9239A9385F9BC762F5400DD22619C199F96E2474B10A6744E0246FA1EC375F9E0654A3D6647F58D502EBE3BCC09A72C76A837DDB7CA653B9728730F2D6DD07511E70349C76663E94AFEB3460ADA3CCD52F986F3B634FBD6FBAF4DC04598C85E874115C43DD7DAC0CEB088E5DF294D47B6A5B3A38C57FC96F437617F48C8CA947F056DAC592F267584770EC9CEBE2108A01BF2D9F6B10077E356A56515FEDA007F2E2F48B253CEAE58165FA9BEB583218471FDC1AD619D4DC1E5C1DB1EC4E01EE3FEA48ED4CAE91C4760B66E9001C906B5411482B800E629F6D96C7798335E9FC6139E420DE8D9AFB7E474839736700ABBAFB20CA8FCCAEB7D7A1CE02D6E4BEE747E836A82FF53F35D867B90F4B8033A578F48D20AFBC5A610AD62CC69A6456FA4958511196B6830C62F74D1DD6DDE59F32EFBBFCB96D4FC17AC980B06F45DB69CFADED8A5BDA86B984A4579735EAB89EB5BD1A35AB1880DB3CB459F5A7CF2D596A186DA2F7343729BEE7F8FCA8BFBE6A97BFCBC1ACF708933B11D86ADCE177F457DA782C6A212DB4F16159B78DEFBCC82352EE606D705336B9460C46B9231D1AD6BD09ADF304EB90BACB75D30675DF3EA64E29835479B7797D5F1B744C9B47B67A7BB0767D75F72265E82AFBA6A55B3DC8E70122C35659B6991301E65CFE6CE9F560BD6DF9F7A5F009B77D2FE2F8E46BD4AC3C1D2BB37B100353E4B1A4CD519B476B9846BFDA34908725AF1E839D1BE53BD0EDB7A18D3A971F5F07B2CC74788D205BC140ABD1797C954EE3076BE96C7BD45221614DD7C3CA71402DD4A87327653192E7C6DC06564C7E8A089D1758F7E075D6B026ED42FD4DD5AF78908B01BEA7EC56D9C5CD9481C8BF5A7715F560BDD4020B3174723937ADF1068E36BDB694FB4B2EFF2EED2B97DF00507715F5607D16ED457F5407EAB11D90A28F597D52A366D5E6136E4D75607BE940AFED461EADEB2EFA9F7D5313878CD7E87F4BDC7545FEE34A7C239ABBE34B77DD5D9CEB6D8300554B87C09A655CA3D714C06661BB40B0B6EDAF8AE9B93902D63D7FEA7993C79418797B41C5C708DD2A1A459BF6D0B0EE595A3DD89D075887581973F56B5FAF7E35FA0C9AC58DBF51065E7623F460BDCBA450AEF34D6D21BB8BF275695FB9FC9B2CBA9E72F95B3F2CF560BD6922EF108A1545ED80CC20D4C6F5B34D4F2AADA2DEF02EFAA930C5B82C4C8BFBD9B6055C8BFA748E3C5989A571DC2216C8D0BFBDCAFF97904FDA2360DB315CBC13B20C1C57A3D7245EA5196104D096C79C2FDA31D29C67CBBA95EBD558327C23B8016E7A4D5ED4DED0365DDD7D10E50EAE21D75D6BCAD77596B026F50B3473F59B97AB693BCAD7A673BC4EB24DC8E7CC9DA8E76AD9C6D510EA3DF54C192BBDA7B26C393286F651FE9C471E1432ACA5EF0D9E871483C3B53ABFEBA9D1C775A0DCDB187E911743CC7191C71CB3B2A20F65F70B1606B0E5EBE91013DBB930FD54BA7A485FBEE3E1FF177EFEDDB79EF898BFC600D631C1E2C259D4D9DA0EB16CC403B4C62BF8AD020517330578791B09978E64E7456E6CB64422F446CA6C316A10EAADEEDEBBF2F9A60687F306EB90B63765656788683FBD74571B3659D63ADC2EB006E0E8AC11A69E04F864DB74BDFBE811BE4DB3AFD05AAE9461BD2D18F721F7C4B9F3BD09584FB5F329451B03EBA84700AFBB17690AD621ED465D4913C1F6A2954020F1D17F7E7F7177D4A83531D165141352C0EB46851F07788D704655B39DAC6DFB345C71FE7EE7F22365746265C6D2BE1EB45D8B8ACED6E8459151B2BD0911F25B4D796249C3CA8F46FB546E1C538F5AE715D6A48DE5270441DDB58F9C8782F526CB5A1D6FF3C8DD2AA0132183319407AC1ED40F05EB0CBE1EAC4FD3B28E154E609A7911D7B62DACC3E0025ABC8BFCEBEE459A8335E6E9537970B6AD6DCFAE1671B0D17A6E99888A30A901D840AA2204BF8DA45FFDDAD7CBF1820282B963809885ACF1B49529DEB686EDE69A888BC70CD723DFA9C9B98BA01E5074B2F651AAE7EFCC1358FB927B951BC794E5769E611DEA3DC1B420EDC11A4874BAAB0979F230DF43693234962A4F1ABA5FD9BDA11FB5F7710A8E3D58EFA3FCD97A3D4B58477DA90FE5ADD1C73278DBBF2BAC83657E2B7BDDBD4853B0668CC9CB3E75651E890742BF8F78E5E9F64D56ECAD1FB86DF5918F6E5E9662E22080ED22544640DB3E963470836D3DA4409955AD32B3054DE2A477C102B0CBC323EF215D028796C7DAA8FC086E4E3B0BAC4EC4B569DCE4B9150EBBAA67C54FCD905F04586B23B9EED477B8E47AB0F664A36EB5B75D43BE37FB84B5F69EDB4C1EBC6DB7FB333C433D58EBB3CED12BD7D290CB7F56B0C69B18B4DAEF89B462304AA34EB76149DC03A0E621F05B5CDDBD48D1875AB70650C735EB8FD9CDAB7EF535FB8513C006E91B6F7ACF6C61ECD3099C4C7AC076E36DEBF06E8E343D186BB8D22C7934D4109C472583F521A0759ACA8014C28D14CA8FB4C22EAB09E6E41E6408684C1A474DB2A68B006BCA6E031D21FCC5CA1C1D23C22EAB2136699FB0A6EC42732FA25F792ACBF726B7A7903E9907B34394FF2C600DA05136F55FA34F287CD6DB5E530B6BC7451E4B81DFDEA75819D3F6C14DF72156B638AFFA2D91465F8DA3E7FEE08260294B0CD03EF2C232116C83F5A609408D8C7B04ACE70AAA70F202747F03D6ADCBE0222ACFF00B7959539E2C12DA0EBA0FB5A375842917085D1458F79E1602D606FA3C404D59A157A37DC3DA93579B9F32C5BC907ED4EE739FCA411DE9BFA751FED386B53A08506F6A978C1169D521A6D4E859E1541C13F366ED764D36AB78EA734CD4452C9BCD731E538AB65DD26BCC37BFF7FDC5AA064537574351F9C8CE3502D0C01CD633931EAC815A3CCB7A0EA8C06B20E85554B83F001A9815505EAEAB4C461E55CC3E8175168AC98F086DC70B2973EE54829B55935C95DA47AF081AD2DC53CB4586753B39932D6FE55E6A1D2DD5BE614DF9692BDA422EEF9C5549B9FCAE6DDFE53F4D587BEA8EB699E70EA6147D2B1B4953C23AEDA8ADAB5DF288BA083EC63D9D72D9646162E4515677283058032F700B01612B37DA0E0D32200EA40AE1515D5A05E83D4EBB488F11F26AD7C08A07669D4A9E6E6C7B1E80776DD2D4A833D5D534BC1E2C7AEEA0F81E410E73D6EF1219249D33E7EB3ED6245D9D26ACAFA67EF324A34ED53EED65900A575BA7598780752F4F7D24A021B8AF9BFA48EFC96EDFAE90D382750BEA6D0C9968234BEF7BB8205A0B78DB3CE26939F2C0CBB8774BEB269E0A1C533E940DD6000DAA6EFCD4A8EB042C6DE00D6B57DA709100774CEC8440C97E70770CCB1DA08D3A7C4EF6F7AC3B830488E7971CCE4A4065545CFA181552860CCAB6016465B04770FE5D9E30DCDF1EA8E7AE21749AB096B76BEA0D6273F2C4969F18F263BE3699EBC0B63658932CD69445740858AB8BF6BAFD068AB6BCB9AC3D4D95BFB772624E0C2CEDA96EAEE934608D1DD1269794BB550C58FA708D9A55F4C3766237267597F41D8A3C62606C619D3939A535587367803508D7FD5D016AB84332345C844E639F49C700B39BCBE2762359C93A876D907623E3D1204BBC86047453694E5B60A2C2741423BA6BABBB2665F06BADA0087316AD9BD39B6C14C4B7B3CA7372EE682C39B8A6D6F29C528675FE1EC43E15F5AB61AADFF039CF8971D0ABDF5E1D45FE6D70ECD2475A6D58FDBBBE1AB5A643C09ADA7B188FE5ED79DCE79A7456FA787B9CA02C4BCB2FDD5CF90F0D6B1C0049796F0B6AE24E507F42BB12AB27208DB4AD7FDA6FE7CFF13D1958F2F99421FAD4523748CC5D947A075737F26D37FCE3AC55A303007ACFD541E0AC428CBCF2647D6B48B6752AC136486C02B0824ABBA4C39E967267771354BCBA535E95EA062AB79154C392A63D46D0E03795DFD34D066584382FA019680D82CEABAE6CBB4EE7E89D5BD0D997D66BBE060DC6F1DB8625034CAE5FE7520EF18ED7B6A27E599753659CEAC86D4769833C1C03463AA9F6CDF8005AB001E1F65C53B03A14ACF59B36DF36284F4DB651BD25A48272791740BDEA9B6DF9F1405B5E52FE43C33A40EDEFA6FE33A5A5B08F39815EBAA579C4FB15395DE4AD4E6BD4AC1C7F9C0F2B1770049DBDA659138BF85D37DFB2D174578940C0C20E2B5B477323B769B83A254B7DE9A3C269A867996D1B74AE6D1E7FA261EC2BC86F9B3AEDC16D97006435CB49EDAB7EE79E180C6C20D23B5600A41860A6D24953B35BD3A1604D3DC80A4BEAB555CF25D706FB36955F7CCD6E4D8782352330FAC152C04D49F963D0997A4A0C7789743D97E7923C18135107F92D447C8CBA05F49E0B38142B479CAFB8AC40018803D8E05DD31669FC261FA7FC7B2A9325686406684EF580B500D6AC6BFB4178C9A8E85C606D84AF5167AEB889BB060D6DDBC1475DB961531D6769707CF8CDB6D1BE60BD692293A281EF1A960E441AFDD594CB796A566B3A24ACF30B30827BBAAD7F9FF4EF29F82F095316E5A160CDF51A79AA7BE75F1A30A46673ACF63EC98F4189719EAC1C13FB9CB71E72426D1E8EC1376D4F1D2CC9A33DDEBD707FF1517BC13E7D35DA2850BBC67AE8A54BD64007ACB9433C728A070BAE8FB5C44702680D4565B8206940DA451B8D9C9095EEE201978BC0C578A493868BC38DECB9543CAEA9385690F3D4E833976BE16702DDA5F054D12A7D09ACE66430F4F8B44D27738DCEEDC6F7EA798994B597F7B661AEE187B4356DE834EA9735A33E979E27EA72CECF18AB0722EC13D6BD270250A8BBB7963EB96DF9DD973977560FD69B56A92C515897BB84A9270FF1536577DFA63C0CAD36E5B1C9278DA99BFAB336879BF5909F0B4403D82C69D09530261EC3827653743ED6B87DC00AEEFCCCD269080A2BE4C62A0D48B36EE42D00B7470579EBB0F2728E7DDCE84349DD289F4777A3B386DC068F372C45E5A887EC45A0ABC368C0CEE15C6E683C96B561174B3ACB60ACD16958BB06F5B4EDBDD41EC04F5B54BFCAD8AB5F6DAF1EB293B4456D19B8DAFC05E715AF532E994C965794599DB9B6254F914BA5AFC4BDF07717AB3ACB352B5FB4A5A9F2E7A7ED9EF4F5B6FC0CB3B947FCA5F2341EF92E0D514FCA57B33921F9EA23CA6EE053566D2E38B644E1D3CF792C5DC1E65CAED5718E974FB4ED8DEC50C1AD850DDA1AAA9BE5222CEFD3B8351C37A7D7189D04C4590335AA2BF07733E5A3D0CEA181BB867D37F4432B9E00CEE249202CD20C6BA376F6975D549D56FD9EE57D3C0F7AB197FFC2093441BAB5B2F99E75FC4D2325AB18D059E9356A56AC70231CB789F302BC63CFD32A908BA229BFE612AB706868E8828AB39C051DC0E6F200D3396B17C859D42CF0291FA9E33D228072F8AF59E980ED78B0F7987F9E26162F923C42F5803D06BFA1A117B85865001CD06635836BCFAF03BEACF0EC270A083B8E1F2926224D6A669F36501B14EAE6D00EE26BEC017BDBB7D58686862E9858C3C00ADAFCD8A0EDAF8923136DAC689671F8B7F9BB58E6260E03CE021007A07B3E31C780F8D412C1A16532909A90CBC0169707C7A1A1A117A8CCEAB3A05B6B1BA405AE12938BB11204786389DE92090B9677AC8BE47FF5480FF06646C5C9D3CCB4DF43F332BFD05B5604D84BD6220F0D0DBD40C4DA066130E6DB06EBB0BAC35D02DC7CA5169C73856CF2779BC40C9000B4C779963AE8F0715BDD00E0E580A18D32F8F596F4BD9056890C0D0D6D2996B3AFE485EB2396F915ABFBC84AF697350EC896E5F14BF363B3D44D26DA6689D7ECCA827160067870016E7FE555930C2D90359CEAAE0DD6D08E2794A1A1A1638130AB9A3F9B65CCD2E342016C2E0D7EEC781DDD763B31C92AF7C2091F2B2BDBA2718BCFF7F1A2C7D0D0D0D0C5D3A54BFF0FC21427D8A33B142D0000000049454E44AE426082DF0000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008D0C9EA79F9BACE118C8200AA004BA90B0200000003000000E0C9EA79F9BACE118C8200AA004BA90B6E000000680074007400700073003A002F002F006D00730064006E002E006D006900630072006F0073006F00660074002E0063006F006D002F0065006E002D00750073002F006C006900620072006100720079002F00630063003600340035003900390033002E0061007300700078000000DF0000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008D0C9EA79F9BACE118C8200AA004BA90B0200000003000000E0C9EA79F9BACE118C8200AA004BA90B6E000000680074007400700073003A002F002F006D00730064006E002E006D006900630072006F0073006F00660074002E0063006F006D002F0065006E002D00750073002F006C006900620072006100720079002F00630063003900340039003100300039002E0061007300700078000000F50000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008D0C9EA79F9BACE118C8200AA004BA90B0200000003000000E0C9EA79F9BACE118C8200AA004BA90B84000000680074007400700073003A002F002F0074006500630068006E00650074002E006D006900630072006F0073006F00660074002E0063006F006D002F0065006E002D00750073002F006D006100670061007A0069006E0065002F0032003000300039002E00300032002E006C006F006700670069006E0067002E006100730070007800000031760000440064000000000000000800000000000000000000000000AE24C50DE803E80300000000000000000000000000000000000000000000000000000000000000000F0004F0D8000000B2040AF00800000002040000000A0000A3000BF0B40000007F0080008000044101000000BF0102001200FF01000008008083140000008183640000008403000000008503000000008603000000008703000000005000690063007400750072006500200039000000680074007400700073003A002F002F0069002D006D00730064006E002E007300650063002E0073002D006D007300660074002E0063006F006D002F00640079006E0069006D0067002F00490043003300340036003100380036002E006700690066000000000010F00400000000000080620007F00575000006069E5E137475B742D1E5699CB3CE298E14FF00E174000001000000E627000000000000006E1EF0D97400009E5E137475B742D1E5699CB3CE298E14FF89504E470D0A1A0A0000000D4948445200000272000000EB0806000000EDD87B37000000017352474200AECE1CE90000000467414D410000B18F0BFC6105000000097048597300000EC300000EC301C76FA8640000745D49444154785EED9D2D94DCB8B6851FBC3074E085034307060E0C0C1D1818D834303030B46160E0C0D0C0C00B870E0CECA7EFF86CF52995FCDF55D5D575F65A5AB2655B3FB6B4B57524DBFF97482412894422914824128944229148241289442291482412894422914824128944229148241289442291482412894422914824128944229148241289442291482412894422914824128944229148241289442291482412894422914824128944229148241289C4ADE2A1E0EBD7FB87BBBB8F0F5FBE7C7EF8F7DF7F1FFC5005611CFBF8693807F8A151FCFAF79F872FF7F7F59A5EBCFFFBA79C538E91367958126F229148240EF1FDC777E35A1CDB1E7C80BFFFFE56CFF9DFCFFF2DE2DAEFDFA7E385B3BF7D7D3C6769BC8944E28980B8FAF3EDDB873F5EFFF1F0FEC3FB873FDFFCF9F0FB7F7F3F68B0344C8E73ECEEC38787DF5FFF6EFB3D612658BCE57CDCFBBFDEDBF95C17E365DBE22DE95BBC255DCE9F8A37914824128760100C7FC2B5B8FFBC7A659CEA874D6C89BB390EE7FEF7B7DF6C10EDA774C1F1A378CBA0DB0F5BBC84B7F1921F3F2591489C1A34EE28CA689826C04A83ACFB659B460A08E35C1A37A32FF67BE0FC376FFEA8D7E0930EE1DA97300484619D8304A6E24D241289C4231810C3C75FBF7EABBC89904274C93A26A117AD651A3CFFF3EFAF2EDF2A5EAC781E64C20E8E563C127ACCBED809051276E2F544227142D0D06870EDA8CCF7AD71D26069B8D19206107734603556C49DC4A0093DE2BD3F1C9521D02017407C43BC3F8FE245F0010F4A241289C408E0D59633D9866B3528D660DC0E3A9C7BAB50E31AB81BB08FD06330CEB6E0A2AFF61936E3F2A18DD7FA8A07A664879044227132F8A8EA60240708870468E86E223F5AF7A0119FC4DBA74F9F1FDEBA05AE25088106AE51A2C4A2AE17201E045E1B9E482412896320E25AC105E063041C807711667EC8F0EBD72F1B8C4BECC1CBC4A56951B6116A6C0BC4455A9AA189625180BBE1F0D6409048244E00175A47828B864823467879233D12565CC3391278345A9186E26DAD789C0B71E03BA93C4026C3D1018A37855C2291484C03BE85537B420E8E457039971E092EAE45A84521C73EBC0D106970BA9D1C409C58E1142F83F8E1C800AE85C353C8251267C09890634A15729813729CD3135CB2E2B5A6751372AF7F7FF8F9E3E7C3FB8FFD78B10E8EC59B4824128947209AE04B8493075520E41062125CAD458E6BA3908BE01856B55121579C0FE28FAE677236855C227126B8C5EC48C8C972C6F1B1295009395E50F0A00A09C4318B1C426E4C20DAA2DC22F652C8251289C43CE0D49E450EB1F5D75FEFD064C6B53E78AE201CC13526E4C62C72C449DC3E9B326A916BC31389C409A01195D6440812622C6C9575CDCFAD60744743071E5431261015171813881004C4043C28914824122340C4B51639F8138B9AAC70BD3572703AE12DFF0BC4D95B23C735884240502B04C7F83F91489C0034441A2AE2C9830CEC6B2486D042584533B9AE8BC440984419DB90404B1C8CE4142F963CE28D24A2EBDE7F3CCC4F22914824FA8043DB17C478E10C7ED5AC085C0C67033BA180AF0A704EE46DB6750E9CCFF1B88E99F8484B037BFA0A5EAAB0830E5DA7781289C489A1356934741A29E670A636E3688A1117E7D04059F7C6425704579C56E51C1AB4BE4944BC3478C2F56570E210B100D2ACF19670488178232125128944621C482F441A0EDE85BBE39BA59CA3652D8471FCEB9761094B1CA0C3C1F0AFB81F01473CC46BD714C1A801BAE235C158E251BC1287EDA7A71289C489A1862F3288620BD06869F034623BE7EDDB830F40028E47E200904ABD66245E041EC7481F8B5D6FCD5D22914824C6C1E017FE148F87A9CF0AF817EE16DFB653AA883D8E479E265E5D8383AFBBF1FA71DCD8546D22913803DA06DAC392735ACC5DC371E0BB89442291D800A7D259BEF5CDC5B0480B7CB78BB9E389442291482412894422914824128944229148241289442291482412894422914824128944229148241289442291482412894422914824128944229148245E1EEC034505BE9B482412892B8253787278227129D000F93A37AEFD39FEA9419AED1F2112894422B10EFC8581BFF4F0DBAC73F22969E9175D1E944824CE09FD9645BFD2C2E7372C7EF8E4E0772EFC9B2FFFAF9A482412EB8190D2BFACE170FDA6EB5C9C4AFAA49DBFE64A242E001AA0441CFF380558C8E28F944F0DFD88991F3F7B502291482416C22D6126A400020E6177CED915383C855C227101FCFAF5CB44D4540384142004E041765D0CC31769FCFAE7579DA6D5F108C230FDFF28E4F3CFBFBFCC1C4F1EE24FF887734A1CDF8778E2C892636D7EC05878229148BC6420DAB0C0F9EE11C6B8B10D8BFB6CC3CD63563D06FE1CE73CF67BFD88F505CEE13A0F9006FBBDB8091B4B339148744083820070C0830F70F7E18359EDE2711A2CE67B59D16878C481258FB5126C636A6FD7BEB14D7C360550E2E4F8FB0FEF8FE2B2343D5F1004BE880002E999F1499B738107251289C48B075CF89F57AF4C3079D001E04E38331E87275BF105EFC2C9260C7DA6E6F7D787D7010DBEC5D19C3FC435AC91236ECED1142FEEBFBFFDF6F0E5FE312DEB274A1ABE6B80FB738A3691D8006FA4B55183E1C880F71F076116C3398FF36545435CD15069F4346040BC900BFB765101626B208661312EE7D0D8894BA3307C0821EE730E24C33ED741007FFDF5AEC6AB30C8C183128944E22680E50B8E866F1155E24E019E5D2AE48A57E310AFE200E7C0F55CC73980F3DE7FFC78C0F584CB12C73EE07CF2A0BC712E7D46B4D49117C2DAFC27128905A0C12182684410426C807777C3E80C78D0D1BA361A1E0D399202202EADB7E37AF625C88436AE1EC85B146E5C13490132208E98EF442291B815C0AF70AD0DA80B37B20D38B6D4226756B2C2D1BE6B68673AC4BD2CAFB1130A38C600BDE5FF08E541C24DD720F0EC8402D26786C6771389C4166029A3D1C651110DEDED9BC3294B4CE4B1716B9416AD6F80304420DB9C0B49C4860BB0BE715E5C2347DA5802AD61170701E0FBE1FF43F49147C505D91037B013128944E20681750E0B59D9AC83E86921F7C8D9706C1C3003C4198374F507ADB01386B80E851CFB0833E2A51F80B325E400837AF205889F38DA3E2491486C00A2AC789504686C1263020DD4C4978FCA688434C8B61112C6B428DB3456B65B21C735C4258B1C0D1D5146E3270F9F3E7DB6EB5A82215F84819E404C2412895B059C08FFB26D42AE59EB066FB6E20BD175C4F55FEC7815601272ED0C4A8C8BB8E163C2E06FAE216EF210851C860385A94F017E3891482C41AFD1F8C8AB0A3946773430B6051A676CCC7A01A127E42014B6498BED766A550D3E8EF844400224D00A399100796909229148246E01F02AF0DD0A59C0D8861BB1AAB16ECD0E16D8E0BBF066B4C8F506EDFE8242E5570417FC2CBE061AC82B2EF6493B8A44AEE79CC8D3E49BF494AE5B121389C41A3042C3F285004394D1C86850B1C1B938B3464903651F0B190E704EDB9005C26491031269A4CB352205CE9128240CD2217DC0B99CD30A398E210C39B7259F442291B805C083703803623855BC0A2F6A30CE3970287CC9713815F1C43971F0AD2950DF35B41639E3FA2200B95E71711DE7282E3E2BC5E09C7300037DCE41DCFD1D96D000E5B59D764D24120B4143A4B1494CD1F8580F47E3F4538C0424C038CEA8092B98488173C6D6C811A737720371293D6BE8771FED1AC84371710EA404599006DB88B8188F40BE7E2B9740061E944824123705F84FFC2D0747033FC52C623A07BE35DE2DFC1A391B6E6E7956424BFC0CB8A6C655E290988B7111A6E31CD3CC4B2BD68857FD41CC6F229158091A130D4F9F05F1E003D0007F86E35CA36DFCB82FB0864E96B608E28A69D946811D2C607B3867F8A8306094E7872B200E4820924C229148DC1AE0C881C30F3FA01E219ED7F196B3D98E6FA302C27AF1B571D979C5D94187CEF175D7D61F003BE8601F1127EB612291B82140008C2C735A35914824AE130CC6735A3591B85130DA6324C788CF83128944227145D0E7497C379148DC1230D3338A031E94482412892B02D3AEED746E229148241289442271DB30334781EFDA9B2BB91831914824128944E20AC002C4F849073E24185F2D4E241289442291483C33608563DD11DF93E18BCE821F36789041FB76C0D1EE03C280EF261289442291485C0C6892DEA755AE1EBC01C807FCF4B5FCE107BCC34FCB6591D3B7BBF4D5662C77BC75A2058B4CC1E200FBDC28AE213EAE7991372E9148241289C4D5405F3E40BFBCB8CF9F20B6107302058C428E307DA9990F00FAE71FEA71041BDF8501DC28CE230E3E261BCF4B241289442291B804D027689BB269C62BB4CF8B1074882F142AE2CB83EA4FCDF5657D0A1A7FEDC1716E826E00E7E274ECDBD7E1EBFC6C73DD2DBE6A4CF9A924F1BEDE0A2833C21F78D0C9401A7B2CBE7BAF3D47191389C4F3C2ADF0CE4BE338CA2221278711EAEA051DD6350AA64250D0F63F97ED391C93058F07CD31D6D7719C6DA65E7174E8F1E6F0FD18C4A05EA478B17EB95F7EFFCCE9FFA28BAFBF62DF85AB39EEC1D2EBB6FAD455EA1CFB73E71EF8E519F16F42AE25CF8BAF731FC7E08576B0F49AF4D34FFF05F8CEEF435FB792778ACF3224C403BCB3F49AE8F3CF531956965EB3D5279D97C471E812EEBDFAA8E8A2850E94B0EB0195899F952BE33E52B002B30F983AA5F2B0CD710AEC1DB6AD8F2B9E5DAF4E9C6BF9AF26C723B849C54B972E5DBA74E9D2A57B760E7D83582FDBD701C4176A9BD185800863A421550AE2D46B6B9DC322421C8073B8098403445FBC21D12247785739BF80F09E60E5DEEC89F31AC225EAA3A36E6D8D6F2ADCFFB77AE0A87B75843C71AD061CADC372CA79F1DC5E1CD4FFF6DA8351EB44DA199EE1197E7DE13F3C7C9C77EE67E3E8F1238EFE82E353D7E28FF14EEFDC3565EB85FB52A9034718C70EAE5B19EF25C30993BE69CB26C7FDE41C37685D076C5AF4B54F2D9542B24FA5E281B18F58C3A7A24AB8E938DB1279D65997F3706FDFFC3154CC1F3FADF26B9DDDAD218AB9AF5F1EAD9B2F1D91ACFC1E9C04D4C7B641D20039B604D4D9E2550741038ECDC1D3A98E7C50F7399648245E2E8C774A9F5936AB3B1FEF7C93A1C41C5384A7E21DC44F4C8BED97C071DCEBF6F9E1780E3CC7A5CFE259814C9379D4AA0AC0C362BD9B14291597CE59C779C038B609E37AF6751CAB9B8421FBB70AEE87AD35FC3858326F093CFF3504B5159154D78A655EC011A96EC92BF51E724B119748DC16E01D59AC7CE0BA18F04CE41D3EF7351C5906F1CE29459C40BF4E3AA4A73EFFDA61C6AB600090056E2DFF276E0858A45E4A03580344954F5F9E1C10A913E36AD0A859FBA941CB5A90EE5A224F2412D70F3A7F8498EFAE0283C86BE11DFAB07371F9392021C7FDC7C299022E310B1A010DDE776F0690CCB91A3F8D71EB142E8D788FE5F0FD87E1AD5CDF4D24123702DAFD2EDEF175E51EB40A43BF721EDE81C75F521F8690C392B9F5DE276E10E76C70CF094CCDF3E280EF9E1490CC2D106A2291783EA0DD3390F3DD5530DE615A75E3F755CFC93BF078CE3A246E1A43834B8BDC29B147C8FDFAF79F7D16B9BFDEDFE4F34D246E1D08A9BD03C87D42EE3CBC6342AE0CCC7D3791B83DDCB2903BA7456ED7C8382D72894462259E8277AEC122C7803C2D72899B060DFD26855C19C19DD522B7513442A47BD7C8DDE2F34D246E1D7B2C72D7C43B39B59AB879D0086ED162732D16390895EF1E6E25D4B4C82512B7893DBC03DFA4452E91B8120C0DEE36A756CF6791BBEC5BAB29E41289DBC31EDE91456E9F904B8B5C227116DCB2903BA7456E2BA1F22AFA1E2177ABCF3791B87520E4D2229748DC001033B7F89DB1730A39FBD4C946212742051EB40A69914B246E137B06907B2D7203EF9CD122976FAD265E321000FCAE850F0C22D834A5F8E9D3677388047ED3C536E138FE7AC0B95CC3B55B45C47306BF7C3B17D1EC25D4776FF7BEB59A249748DC1A2E6A912BE2EA6C42AE705C5AE4122F06FA2234428C06CC2F3E1001B8CFEF06C186FFEDD3FB872F776FAB2FC73EEEEE6E38FFC3BB37760D8BED71D660CAC80771B7F5D72D9780A9A002F22CC7FF76558ED6097EF96EEC59AB426ED222974824D6620FEFECB5C89D7300298383EF2612D7092A320DC77E80FFC71B13653FEE3F3C3C7CFFFC64EEDFAF7755E49106228F9FED3FB7068410C39A08896065E4BE2066B83712B57294216E2356ED1EFEF5DEAED1DA0BE2E21EFFF3EF3652E3FAAD236311EA562137106A0AB944E2D6B08777E09BE7B4468EFCD0D7E0E062385E8ED995B86F612EEE18B0038F2691787EA08262C2468420B2105CBFFEF7E548843DB5230D093BD246305DB2B1FCFCF1D3EE03220C479E6479C4216A256CC9B7CAA16DFCB8ADF3B916514C5CB26822F2107808464F7E16BB47C6BB2D7239B59A48DC1A2E6991DBC33B702B420C9E856FC5EB91DF97389DABEB888BBE8AB8D7F077227132D0B1D34825E05A1785C9127FEED89443ECD0E83C6B67030D528D55824D797A2A413BC473FFF0EBC7703F4883F262957CFFF1FD2242788A9131F0A055488B5C22719BB8268B1C3C6AF92D624B33237F7F1C669670F37DD17D276CE06CDCCFAF5F2A77D35F90066991668ABAC4C540E5FBFDBFBF8F56DEA9FD2D2EC6D18B9F46EF593B3920996F5FBF5B838CE26D8D5319F6DC1BC423843337BD0C596031F4DD55D0C81878D02AA4452E91B84D5CD2223708B965BCC379F028B31E5BF97C8B232DCDB42447262E027EA6FE9F57AF26C54C4F7061596A8FD5ED326AE95D13F75B8798210F7FBCFEE36C0D81B233A21AF2303E129BF25BD73B3EB61D1DF71E22F0AC7561426E07A15A59370AB9B4C82512B70978E7B95BE478318FFE037E5D348B52FAA86E7870635CDD735A2684A0CB4F9824CE0E2C727FFDF1DBC3F7BBD7E6D318F492C35091EF574C2FDE4F54FE615A5102108778C3F19280F2C01BB29EB5938329D5FFFEF6DB918055199636E4A5E74D39EEF99C3572F777E4D22297482456E29216B925BC03A7D16FF47855AEE5F4E88F1D931B3BDE9E2777CE3E2C913020E4DEFCFEDBC3C3FD9F0F0F9FDF3CFCFDFE0F13557AA3149165A38C2234B47E8C75026395380A35AD27C0712D7140088AFB6D49E7EEED20E01EBE0CE99F736A95A94CCA4E1EB086B582AE75B1CCBDF253DEF6D8D87DC2718C3581DC8B0F6F7E33C2F3AC75B1C722C773DE23E4968E8C1389C4CBC2452D720BBE2307B731AB443F35F0EDE3ECCA18FF4EF1B2DC9273A283FFE1F2DF5FFF9E3C99382F6804082A84D4AF2F6F064155441DDB082C84DD9722742436F011627FFEF1FBAC235E5BCC5FDCA737C3F42DA2E9EFBF06F156D37311C73ED37F9EB59303218768255DF2443ED947D4213A254425D00EDDA385318A571D3BDC1FA64E89478216814C59B92FDC8B7F3EBE5E30B5BA7D642C42051EB40A69914B246E1397B4C80D03C869DEB1344A7F435FF5F6DDEBBA462EF2F631471FBA28DAE6045C8C8B73498BCF69C1E7F423E7ECC31209436B9193A03391E5E24AC7D846700C6ED81E44C8F1B6FC9FF76FCD577CE688CF05DCAF8FA59187B4CE6D913311EBF9217D89570416C7A275120749402E8831B9AF7FDD59438E619CA36B70C4A1F8D8A7C1738F743FD89E2BFB9E9131648778DC2AE406424D8B5C22716BB8A8456E01EF10B7FA30FA1AF8D506E4381F946B198F665D0E07E771F9D030407FF4877325D8148FF85DBC8EB1437C9E53AB89B3235AE47054C641B0954AE9E2C684966FDB792EBA748D8991C6B7E3ECCB85E316A70B3839C249F39C8D401639E5E928BF1E2E7187F83221571A2DCE041E56CAE2D897C552FB9CCB755C8FB3785D1457DF9D09B9D9A9D5ED23E3A7F9B3435AE412895BC3252D724B78076EAB03F2C0AD883A0DCAE16A71B6F176E1692C67F89A1DD1B689B3778320D4B907BE733E719386FA0AA59B16B9C4D9316691C3979893B8ABD6333F0717055FEB47377AACB1C89DB3111C58E4BCEC319F5636C2395E9C85FBF622C7B5234E69C8911624E259EB62AF452ED7C8251289B578F616B97FFFB1A9D5517E752E264C836A3906E7E67CA01EB71988C7730F66969CE3B55FC38B4B8B5CE2ECF8F5CFAF033113C51BBE1A04BEDCD83931DCCE2D22ADDD6FAFD7B56A0CE79E5A358B5C297BCD63C8A7F275708C706FB0D5719E9FDBBA7A4D39DEFA6DBCF316B99DDF914B8B5C229158894B5AE4062137B346AEF46126E49C8723CF46679CEC024CDC6CD7B02FBF380B0F7EBD4ED7045F7D598DAB84A5452E7176309A195D2357B65551DB0A1B7D099FEEB166BB174F4CE3DC42AEB5C89107E535E651C7B41F8FF5CA147DC5A9EDB1739658E4B612AA46C65B855C5AE41289DBC473B7C8D5A95517583D8341E55A78DECF8BFC3BACE57E0CD3B9DA6E5DBCD6C2421F9816B9C4D9D17B6B3536805859DB63F11CDC51D844838AC70953A339F7D4AAD6C8295FD1EFE57B693861B171C7B2B6C7293B617316B93DDF91D3C81878D02AA4452E91B84D5CD222B78477EAD4AA73B17836FAE61A0E3EE4E28187DB73ED7CE7E7F6BA83EBFD3C5C5AE4CE88B51D1AE7237AD65EF7DC11D7C8A902AB4253511586AFCA1B8FB5E71C8435FBBD73639CB84B59E4625E7AE5EC8599EB94FBE07871766D2089783CA6794A8B1C440AC16CADBF69914B246E1317B5C82DF88EDC3FFFFAF220F16AD35F45EE8EE16CB77EE4F376DF845A38FF20DE70DE39FF4E74B3E003AC542C397E78CB17FEFDF028FEFEFB9B3DA025E75E13EA1A3955C8E05459B55DC548A7A1B4D78CF9764E89A7BD466117796BB50839E551F969CB12F72DDFA1E1B661BAA6BD3686C93772F0B2CFAF91DB3E3236424D8B5C229158894B5AE48601E4F23572E264B98330E767858987E331B91A1E8EE9FC785D8C5F5C9E16B933801FC4E310665410BE33C357A1BF7F9F166874FA88402C581EF422F0BF7FFE791472AACC8D2069B7E5B45FC34363980AC36F8F6BFFDC53ABB2C8D100637E62438D65AFF9F6737AE1316CEC1EB63EC7E685DCF69131F5768F904B8B5C22719BD8C33BF0CD2E8BDC02DEB134C25BABB5CF095C5EF9BD0D77FE8DFB354CF1C885FDF69C184F0AB933807F6BB61D26FB5436C07EF405F65BC4703BA9C0770D1ED4BD162C99AAB5131C1E7484A9637318B3C869BFE7ABC2E3DBF9AACCA5B1B461317CF69AE2CE2DE4CC2257F2A0F21DE44D6586043C2C96A31E0FE58AC7E3B1DEB9F11EE1E6A756775AE4421D5F8BB4C82512B7894B5AE496F08E0D52472C72B81ADEF02DE1B16FAAC7C2796DFF14CF8FE10AE3780AB933006B5C2BE4A82884033A772A0F53A89CA7E9541CD3B0B2C871AEA665BF7CF96C9D24E7B2201D50F10963AA308E2838467A1CD371CE057E8AFDCC9D30CB839F873530A62FD868A984C7EBD780F8E25BABB192B2DF0A18ABCC8D2FD7862FBD468EF329AB67EDE4881639F252CBACFC350D1F77548ED8E89BB0786EEF5EE0146E656FEA650B7BD61B47C6102942716B3DA13EA6452E91B83DECE11DF8064E3FA545EEE83B72816F23EF5637C1D976BEF7013A861FE38AE1F15AB95C2377069845AE110B0821DD7CC413E7B0FFE9D3679B8245EC7CFBFADDA660A390E3E7B8084044D6F71F3F356AB1F807213684711DA281EBF0399FCAC9363EE92106390E98E6551E08270FE48B78E279E48173C8BF07AD06E58916B9A34AEA8E7D2AB2ED978A4B656F1B4BF4631C63E71C9CEB8DE72216B990CF985FB6E37EEBDB31BF0F766ED3A00FCE2BDBF8EDB9842B8E452F3B6CFC8E5CFED92191486C017D94F76DABB1D7223708B9E56BE4C4B9E25BF9917371539C2D5FF1B4F1B57D5FBC966369913B03105E58C1581B265155824D2C71DC05D781600254264453147288AD28A20843DCC59F9F136682EC7EBC321247BCC6D7EB1D55602A75EC8C1177C4ED79DE846A912B15B056DAB8DD84A9D2AAE28EF9B58287863276BECEE19A56649F12DCB78335724D5E0FCAAF3C87FBD0FAB8788D8E1D5CDF399738F98ED11C019890DB49A8AA3B6B31106A5AE412895B03BCF3AC2D72709B5BE4C4AD91835BB1D6EE47CE8EBE8EB761AD1FFB2FF29042EE0C406861D942CCE1A864541475708823C45E2B8EA8CC844BC851791051516CA9D24A1402C2B0B4B8603410463A5C8BC0231F511072BDE5A1884D0F32104EDE7FFEF869E1C4B9A77306D522E7D38BB162F62A6EACECF1DC76BF5E532A76BCA677ADCE3B7723E019478B5C7523E5D776AF3CD16FCF8BFB16CFC83D9A9B5ADDFD1DB93008588BB4C82512B7894B5AE496F04EFB1DB9967BAB0BFD4DDC8FD7B5BEE269FBB178BD9D4BFFE5E7A5903B031048746866912BAEEDD826855C118151C8B1DF5ADA0661782CEE98A6659FEB691488402A388EF4E288C7845C484B202EB3EEB9B590785BCBE15A908659E4A884C5A962E262C5D5B1D68FE7F5F663780CAB8DC1F7714BAC524F896891B3BC8486D996BD3A1A2C16BC761B17B79B6373F788FD392147BDDA4AA8AA87C0835661C9C8389148BC3CC03B17B3C82DF88E5CFCB343E5DAB8EDBEB8F740808573E2B11836E68F9D471FED594B9C0A1272BE7B0413724544E17B90814E8C6B25AEF05B8B1C20EE9E9093458E6358D5809D5080352E5AE4985AED89498020541AE4B377CE1AD4B756111DA5F2C78ADF5650C2F0DBCACE75313C5E3F768D85C56B88A31CBBA4454EE5B7ED98C7E23EFFF1A7DDA79E238EDEB61C3F61AEF175EE91D23DE55BAB1A19C77AB70669914B246E1397B4C80D03C869DE59FA67871A667CCB4FF0A33F17E67DC1827E2C2D726780BDEC3061F9E00585318B1CC24DD39D74889C7764912B71C78AC779082F59CEF0B90EB02F41B8646A1510C631445CBC662BAA45CE855C6C00AAACB1D2C6CA5BB7BD1247D73BFFA0F277AEC14D89ECA746B4C88D959D7D1AF320EE7FAE76086F138B9E462C6B9BDE128BDCD69131440AC1A8DEAD455AE41289DBC41EDE816FE0F47D426E9A77E29F1D2277E31BD7368367441FCB99E0C3E8DA30EDDB12AC72CD8777250EE770E28A7147C7F99EB5C4A9A0F571BE7B042C7188BD638BDC604993458E8A6942AE99DAB4A9CF20EEA8C884C9228710A362E3A8A4842312E2CB0E0839F230666DF30EFF492C2494478DA056C650F17B616D0391E3988EF77C6B04CD35F118DBE76C04D52257441669AB0CCAD3E3FE6B6BD05BC0DBCE1FDEF4EF6FBDA75EF6937F47AED41BE041AB9016B944E23671498BDC12DE89DF426DB93BF22BDB70397DEF5A30288F837EC537C439A445388EBEC2B39638151049AD488BC04CCB39540E0F3220780807ECE3B3DF5ACD883B5ECB79844551465C08381CE1B89827A5C5DCBF071D808A8D381C3BBE06A415DF5A3DAA9C725E49754C7ECFB5E7E85A6B04C1FAA5F4E4E3CED908B8EFAD45AEE657DBEE8F0939EE1FCF7B0C90A009B99246BC1F2A2F4E699CD222473EF708B9B4C82512B7893DBC03DF9CDA226769FC31BCB5AABE247237BEDCF7BB22E49C07D7002167837ED208E9C88FDBF4CD9EB544A20F2A1515315AF0F6800E5E62A6ADF4EC53F1BFBC1DD679DD151FF332FEFB3F8AB829D7B16FEBC28AD089E1F808189D8FAF7888F3202D848D5BA7CE2DE4AC71963CC486A83C4978B2760F4B610B9E83ACABC4D5032454A756712A7371F51E94B4D83EE577E4C88B46A21EB40A69914B246E1397B4C80D426E9A776C908A90735E6DB91CDFB68D675F1BCFB6C0904239496BF8DFD221AA45AE4903DEB6F8C3EC4A5AE412B3A0C2F5A67EB7A25AE410192E284C78B908C351F14D88DDBD7DF8F6E9BDB91FF71F1E7E7EFDD2F5FFFD7A57B7753ED7C6B81037A4F1F91D8DE1F520984A43406C78D64E8E9E458E3C700F109BE4F3D39B57768E114503F2CAA760A60039707FED7E1627212B22B0744BFAA409E179D6BA3021B7835045601EB40A69914B246E13F0CE73B6C83123522D72CEE3F0A9F16BD88673FFFE6BF8214004C28D65529491F426859CA751F91B17F6F1C98B672D91E8834A4BC5061EB40BC44705FD79FFDFE1CDCC77AF4D5C49AC21CA1EBE7F7EF8F5BF2FE6EF718A833825F2EEEEFE1C445D114D5A8BE6593B39AA45CE85148D3C5A1A751F10A13D8B1C61900253E463E05911DF97FBBB2A664983C68E6046D8D1F871082DCF5A177BBE23073989C03C6815D2229748DC26E0B03D03C83D16B925BC636948C8B9B0D2609C59A0F8C501CE6B859C5D5FC2C6665500C730A0281E192134BB54855D493B2D7289B3834ACA342DE202A13108B7FBC5C24D426F2E6CCA713E699BB8D948185B208B1C8D91C687C842B8919F5F3F0EF3D8367E40189651AC9A63407CD1E087FB796F7111B7842CF75D828EF83C6B5DECB5C841A8C083568174D3229748DC1E2E6A915BF01D39E286C719906B2685013A03E36894807BD9160F466091239C97177B80E7E9238883D926E2216EC2648820ED1472898B80973B1072265E66C45B14683DB1D63B3EE61FBB7B6B6C4FF14995A540C8D9B467698434CEB1F293E7EE1A3917725340FC107F2F5E1C69420A460833EB1E778F8C5D8C7AD02AA4452E91B84D5CD222370C20A77987CF8F6004C0FA2683047C2E7E8D7C0B97B7424EDC383520B7A9551772AD234ECDB690877CD9217176507931196BC4122B676F7BEC580C9335ABB56AB5AE8D174173EECF8F4C35CEB8DD1BC521BCA6CCF1008B1C0D7C4E24433C7353AB4F3132061EB40A69914B246E1317B5C82DE01DD2B0CF7E153135D6E788CFE9E7E0ED08F2C6F57C81620C0CD81189E33C7E6F69D8CC5229AF672D91380FA8BC5A8C4FA3791474C334E09853C3880D47DB3AD6FA7D3758E2582B471ECE399A4184F16D4004642F6FB13C3D8BDC12F42C72EDFD601F333D62D1B3D6C5538C8C8107AD425AE41289DBC4252D724B78C7D2C0A2D6E967DA30FA1A1BBC07703DEB9CA72D72DF6DFD781B2FFE631F38F49929E41267079597F5057C6243A6698407C28205FABDC6B1DC1D8A41C54563423C696D1E6B0C5823C6A2D139ABD45382374E11B1949B74C9934CF26DBE39BE05531639D292499E7572A7B4C8415622300F5A85B4C82512B789E76E91D3AC123CDAE36FDCD0F70C4683D622B7044CADD257F5E296236E389C0FFC7BD61289F3406FADDA2738ECEDCDD7B668132187858CB5070800093C8487B922F2103E738E73B1B6111F95DCE2F3C5A1BC25AAB77E2CFDCF67FEB3C33FFFD4B756C907628ABC5156F24CFE699C38F2353E5E1B8791A01380EE09F78230D2224DD2B6D7D6672D723BBF239716B94422B11297B4C80D426E8145AEF42BF0289C6A4688D2EF20EACC626683E8E1053EF611966B11A7563528272ED280D3E9CF384E9F467FE9594B8C81E9301E2E37D683123B80983121E7DFC0414CC9C721B2A2B84378F03A370268CE9920E2FC721D155C5637136EC4CFEBDA4AD7FD739AA5B1C8914F8948955D655519B83F4CF96E0124C86831DE17E2260DA549D9B9278B84DC464265D4BA47C82D191927128997071B8C3E638B1C715B1F56781CFE6686857E07AE456049D86920DD4EAD2E017A03B1C8F5C485558FB8C5E9FA8C14794821B700080F2A86BD2E5C7C5E1746DCF9E1C44A548B5C1055D155B12187E859EB5CAC1C6C17DF045D93E6391B01F58646A87C1D95B9842362717BD6C8717F2D5EDD8F905EBC177353AB7BBE23475E3412F5A055488B5C22719BB8A4456E09EFD820B5882CE36CF533C6DD8FDF92437431C304178B07D780A9557DE10091489CC41D795D7D470AB985186EECF7874F9F868585CC49F3D90A1E380FD54F4B2C40B4C8495899EF8D82CA296761C5C56D6B388D3B38EEE71CC4A37314EEBF37215D9EA767EDE440C8C5919CCA6D790BF9277CBB90BB3702B1C6EEF1599983E33E58D94F68918348B5CECF8356212D7289C46D02DEB998456EC177E4480391553936F42FE602F722BEC4836BD0FED9C1E224EEB24D5AB1EF38E7F2A017059BBF1EBE3F36FC6AA36CC71FDC27C671B046CE2B626C085641C33EE7B461ECB32D1F61168FC7F35ADFCEE7B8A77D118B5CC863DC56BEF65AE44CC8C534DA7BE8FB7316B93D23E3FCB3432291D8824B5AE48601E4CC1AB97FFF192C72CEA7E6F4EFD3C0B1E2F2AD42CEFA0A8F8778DBFE4B2E2D721B80058EE9553A295B8BF4D73B736CEF5913742B88163955CEE8AB31B4FB5681BDB1C4B07A2C1CEF5DDBC6C13EE75DCA2247031C2FFBF0E78716900C714052089D1E3E7DFDBB5AE4ACBCA1EC35AD72CCCABEC022B775642C42051EB40A69914B246E1317B5C82DE01D06A9D55AE69C2AAE6DB91C8B5C8FCBD11142DC16AA906B0C1E95C33D0D5C7E107821B8D1542E3A26BE0386B584EFC0D0A9FA29FFC78DD7EF363C28D1415C23A78A18B75BA1A563B1B1C4630A6F8FC7F32C3C88403BE68DE3D216B99AA78372F72D721014D660EA238DB74700D122D72BBF857BD94F699133219716B94422B11297B4C82DE11DFA3059E470E2D547FE7EE459B85C035A417984BFE913DAE3A04EAD76E28D3C8E4B8BDC0270A3993E7D8E53A8E483CA109DF2864FDEE33EE293FCB3BF05165981EF6EC2C15BAB2E2E6205AD2E0AAF0391735899E5C763F8F13AB9785CD75ED22257F3E2C20AA7B0DE288EBC72FF78CE6C1FCBB8B046CEE3543971BA2F4A0302F1AC75F1142363E041AB9016B944E236F114BC734A8B9C09317FD941BC5AB9DCF9161FD7B3C8C1DF0CD4F1F992817832E2606AD5E33417FA3485E71AB905C00262D6B7D2817AD0B38075E6A523C632C383C4B1AD910CF9467C4AB85139D8A72CECAF058D8BF8B13A7AD0268C59E424327A1595CA5C8F7B787B7EDB88746E3C271E57233C6723A816399FDA8C79AA79B4B20E16B956A80D24736F56395EB891708F881639C5DFDE1BDDCF798BDCF6EFC869D4093C6815D2229748DC262E699113C7FA6E17ED1AB99E6F9CEB5CDE5ADC2C8F2E36975AE462BF8813A7930679F1AC25C68010E2A6FBEEB30115A07856E179E874EEDFBF7FAFD3BD74F2544809502A07E5582BE4880F4B24C28269E5AD1DBB60A39

    and DocType column  -- doc

    Can anyone help me to figure out what mistake i did here and solution for that ?

    Regards


    Friday, February 2, 2018 7:00 PM

Answers

  • Hi Sourabh Tiwari,

    >> I am trying same on my machine but it is giving some other result instead what I am looking for.

    So what exactly are you looking for? Content within the doc file? As I mentioned earlier, SQL Server stores .doc file as binary data, thus when you run select statement against the table, getting hex is expected. And I run the same code on my machine with the same result as yours. Besides, it’s not a good practice to directly store binary data in a table in SQL Server. You’ll need to read out the doc content programmatically before storing it to the table.

    If you really want to do this, you can refer to this link to read varbinary word doc file using PowerShell.

    If you have any other questions, please let me know.

    Regards,

    Hannah

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.



    Friday, February 16, 2018 7:26 AM

All replies

  • Hello Dileep,

    "Thanks" for posting tons of useless hex's.

    With this query you can see if docx & other Office doc types are included in the currently supported document types:

    SELECT *
    FROM [sys].[fulltext_document_types]
    WHERE document_type in ('.doc', '.docx', '.xls', '.xlsx')
    If they are not included, then you have to install additional filter, see Get the Office 2010 Filter Pack for search in SQL Server 2012

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Saturday, February 3, 2018 5:58 AM

  • Hi Olaf,

    Thanks for replying.

    Sorry for hexes(Wasn't able to attach snapshot)

    These document type are included as i installed it earlier while troubleshooting but it is still giving output in hex .

    Any idea or solution ?

    Regards

    Saturday, February 3, 2018 7:18 AM
  • Hi Sourabh Tiwari,

    Please refer to the following article which illustrates how to create fulltext index with doc. You can perform the steps described in this article and try to identify where you might go wrong in your script.

    Understanding Full-Text Indexing in SQL Server

    If you have any other questions, please let me know.

    Regards,

    Hannah


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, February 8, 2018 8:57 AM
  • Hi Sourabh Tiwari,

    Please refer to the following article which illustrates how to create fulltext index with doc. You can perform the steps described in this article and try to identify where you might go wrong in your script.

    Understanding Full-Text Indexing in SQL Server

    If you have any other questions, please let me know.

    Regards,

    Hannah


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Hi Hannah,

    Thanks for reply and article.

    I've gone through this article earlier but it din't help much.

    Thanks


    Friday, February 9, 2018 2:35 PM
  • Hi Sourabh Tiwari,

    Based on my test, SQL Server stores .doc file as binary data. What is your intention here? To store the .doc file or the content(string) within the .doc file?

    I’m also interested in why you create fulltext index here? As far as I know, index helps to improve performance when selecting against a specified table, and it does not make sense to create index for binary data. Besides, I assume that you might mix the concept of doc(word) and doc(fulltext).

    If you have any other questions, please let me know.

    Regards,

    Hannah


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, February 13, 2018 9:17 AM
  • Hi Sourabh Tiwari,

    Based on my test, SQL Server stores .doc file as binary data. What is your intention here? To store the .doc file or the content(string) within the .doc file?

    I’m also interested in why you create fulltext index here? As far as I know, index helps to improve performance when selecting against a specified table, and it does not make sense to create index for binary data. Besides, I assume that you might mix the concept of doc(word) and doc(fulltext).

    If you have any other questions, please let me know.

    Regards,

    Hannah


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Hi Hannah,

     

    Sorry for the late reply.

    Actually i have to work on Full text index on some environments. So i am trying to setup full text on my local first with the help of book(expert performance indexing for sql server 2012).In this book, user  inserted the doc file in a table and triggered select statement on table after creating index on table .I am trying same on my machine but it is giving some other result instead what I am looking for.

    Regards




    Wednesday, February 14, 2018 7:33 PM
  • Hi Sourabh Tiwari,

    >> I am trying same on my machine but it is giving some other result instead what I am looking for.

    So what exactly are you looking for? Content within the doc file? As I mentioned earlier, SQL Server stores .doc file as binary data, thus when you run select statement against the table, getting hex is expected. And I run the same code on my machine with the same result as yours. Besides, it’s not a good practice to directly store binary data in a table in SQL Server. You’ll need to read out the doc content programmatically before storing it to the table.

    If you really want to do this, you can refer to this link to read varbinary word doc file using PowerShell.

    If you have any other questions, please let me know.

    Regards,

    Hannah

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.



    Friday, February 16, 2018 7:26 AM
  • Hi Sourabh Tiwari,

    >> I am trying same on my machine but it is giving some other result instead what I am looking for.

    So what exactly are you looking for? Content within the doc file? As I mentioned earlier, SQL Server stores .doc file as binary data, thus when you run select statement against the table, getting hex is expected. And I run the same code on my machine with the same result as yours. Besides, it’s not a good practice to directly store binary data in a table in SQL Server. You’ll need to read out the doc content programmatically before storing it to the table.

    If you really want to do this, you can refer to this link to read varbinary word doc file using PowerShell.

    If you have any other questions, please let me know.

    Regards,

    Hannah

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.



    Hi Hannah,

    Thanks.It is clear now.

    Regards

    Friday, February 16, 2018 6:06 PM