search string in varbinary column of SQL Server table -

-

मेरी एक तालिका है जिसमें 3 कॉलम हैं:

  • समस्या ID
  • फ़ाइल संवेदक
  • फाइलनाम

    मैं एक उपयोगकर्ता निर्दिष्ट स्ट्रिंग को fileContent कॉलम से खोजना चाहता हूं। क्या यह VARCHAR में बाइनरी डेटा को परिवर्तित करना संभव है? मैंने इसे करने की कोशिश की लेकिन यह परिणाम अलग स्वरूप में देता है मैं एसएसएल सर्वर में असली बाइनरी डेटा नहीं खोज सकता है अगर द्विआधारी। पीडीएफ फाइलें केवल

    फ़ॉर्मेट वर्ड या एक्सेल या कच्चे टेक्स्ट फ़ाइल को छोड़कर कुछ भी है

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

ruby on rails - Convert a Activerecord result with has_one associations into a single hash per record -

-
If I have any results from the Active Records, then I have an array of hashes, if I have a reliable load, then every Each organization hash in record hash has a nested hash of its associated records My question is, is there a quick rail system that allows you to merge these nested hashes into a hash per record? An analogy will be changing the records table rows Another resemblance will be converted into a hash at one level of nested hashes. approach 1: select them in the section Include class user has_one: profile end is for square profile: user # street 1, street 2, city etc. end profile = profile.junks (user :). Selection ("User. *, Profile. *") All profiles. First.login Approach 2: Use delegation for class profiles : User # Street 1, Road 2, City etc. Representative: Name ,: name =,: email,: email = ,: from = to & gt; : End of user
Read more

c# - GetType() == type perfomance question -

-
I am making an XNA game and I am calling the following updates 2 to 20 times the code. I tried googling and it seems that it is half slow, so I thought I was asking what kind of fast way to compare the type? code: Public modifier for this [type type] {for (int i = 0; i & lt; this.Qount; i ++) {if ( It [I.] Type GETType () ==) {Please return this [ii]; }} New NotImplementedException Throw ("Fix It"); } Set {for (int i = 0; i & lt; this.Qount; i ++) {if (this [i]. Type GetType () ==) {this [i] = value; }} If (System. Diagnostics.Debugor.ISAcredited) system. Diagnostics. Debugger. Break (); }} This code is in the modifier collection section which comes from a list. The modifier is a part of the particle engine. In addition, my game is not in a situation where I can actually do this test, so I can not test it, but should it work right? I read something about runtime typhanies, which is fast, should I use it? Thanks a lot! Edit: What I'm aiming to do ...
Read more