Is there a way to do an accent/diacritic insensitive search in sqlite?  Googling, I've found , but I sincerely don't know how to create my "collation function" in C#. I'm trying create the pt-br collation for Sqlite...
Sqlite3 by default sorts only by ascii letters. I tried to look in google, but the only thing I found were informations about collations. Sqlite3 has only NOCASE, RTRIM and BIARY collations. How to add support for a specific locale? (I'm using it in Rails application)
Using global variables in a function How can I create or use a global variable in a function?  If I create a global variable in one function, how can I use that global variable in another function? Do I need to store the global variable in a local variable of the function which needs its access? I have a small server which I use for testing and programming. Currently it runs Debian 9.4 stretch with 4.14.0-0.bpo.3-amd64 kernel.  Today I tried to connect through SSH but I couldn't then I tried to ping it and it was unreachable. Therefore I had to hard-restart it by unplugging power cable. Then I went to  /var/log/syslog  and I found a strange line containing exactly 6140 characters like the following  ^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@  then nothing else until new log entries of system restart. This is actually the first time it happens.  Does someone know what could it be? iOS 9.2 double touch fingerprint sensor I was messing around this morning and found that if I quickly double touch (NOT double-click) the fingerprint sensor on my iPhone 6S+ (iOS 9.2), the current app (or the home screen) slides down to the bottom half-screen, showing a blurred home screen background on the top half.  It doesn't matter if I use a finger that the sensor recognizes.  It goes back to normal after about 8 seconds or if you double-touch again, but I can't figure out what this mode is for??  Is this a bug or some hidden feature I haven't heard about yet? One adjective for two or more nouns Could we use one adjective for two nouns? Is the following sentence correct?     It has low speed and voltage. Add 1Password extensions support to the SE iOS app Please implement the URL scheme to call 1Password for password lookups on the iOS app.   a URL scheme for switching to 1Password to search item titles for a custom term, usually a service name like “twitter” or “evernote”. This speeds up the process for the user so they can copy something like their password and get back to your app  That will ease sign up speed using long, complicated or unmemorable passwords for many users of both apps. In the two years since the above blog was published there are now updated instructions for implementation and code on github: I am trying to show that $a^{12} \equiv 1 \mod 32760$ for each $a \in \mathbb{Z}$ coprime to $32760$. I have found the prime decomposition $32760 = 2^3 \cdot 3^3 \cdot 5 \cdot 7 \cdot 13$ and determined $\phi(32760)$, where $\phi$ is the Euler's totient function. This gives me that $\phi (32760) = 8640$.   Using Euler's congruence, this gives that $a^{8640} \equiv 1 \mod 32760$, but this is still far from the result I want to show... I also know a consequence of Eulers congruence, which states that $e \equiv e' \mod \phi (n)$ implies that $a^e \equiv a^{e'} \mod n$, but I do not see how to use this...  Any hints would be appreciated.  $\textbf{EDIT:}$ I made a mistake in my primefactorization, it is edited now. the converse of Pythagoras Theorem What are the light blue lines on my imported objects Which is the simplest way to update a Label from another Thread?   I have a Form running on thread1, and from that I'm starting another thread (thread2).  While thread2 is processing some files I would like to update a Label on the Form with the current status of thread2's work.   How could I do that? What do I need to consider to choose between dSLR, mirrorless, or a compact as my first "serious" camera? I am thinking of buying a camera to learn photography. Most of the time I'll be shooting portraits and landscapes. But I am not sure where I should start. Most of my friends tell me that I should get an entry level DSLR, but I am not sure if I have the persistence and enthusiasm to carry it all day in a backpack. But the camera on my cellphone doesn't seem to be enough to begin with.  So what I want is some expert advice (preferably with professional experience). Can most compact fixed-lens or mirrorless cameras fit the situations I mentioned? Or do I really need to go to a DSLR to get a tool to learn photography? Acount suspension reason is only shown on the main site profile not meta How does LSTM prevent the vanishing gradient problem? LSTM was invented specifically to avoid the vanishing gradient problem. It is supposed to do that with the Constant Error Carousel (CEC), which on the diagram below (from ) correspond to the loop around cell.  (source: ) And I understand that that part can be seen as a sort of identity function, so the derivative is one and the gradient stays constant. What I don't understand is how it does not vanish due to the other activation functions ? The input, output and forget gates use a sigmoid, which derivative is at most 0.25, and g and h were traditionally tanh. How does backpropagating through those not make the gradient vanish ? How to start Ubuntu in Console mode Redirect the output using `sudo` I have a small question regarding using sudo with output redirect &gt;. To enable IP forwrding, someone can use the command:  echo 1 &gt; /proc/sys/net/ipv4/ip_forward   Executing this command will give permission denied as it requires root privileges. However, executing the same command with sudo gives also permission denied error! It seems that output redirect &gt; does not inherit the permissions of the preceding command echo. Is this right?  As a workaround I do:  echo 1 | sudo tee /proc/sys/net/ipv4/ip_forward   Is this the best way to do it? Am I missing something?  Please, note that this is an example and it applies to all commands that use output redirect. Do you really want to create a new tag? What is the most efficient way to clone a JavaScript object? I've seen obj = eval(uneval(o)); being used, but . I've done things like obj = JSON.parse(JSON.stringify(o)); but question the efficiency.  I've also seen recursive copying functions with various flaws.  I'm surprised no canonical solution exists. How far into space does one have to travel to see the entire sphere of earth? Virgin Galactic will take passengers aboard SpaceShipTwo  above the surface of the earth. But from this altitude, passengers will only be able to see a certain segment of the curvature of the earth through .  How much further into space would SpaceShipTwo have to travel to give passengers a view of the entire sphere of earth through one of these windows? The following question was asked on a high school test, where the students were given a few minutes per question, at most:     Given that,   $$P(x)=x^{104}+x^{93}+x^{82}+x^{71}+1$$   and,   $$Q(x)=x^4+x^3+x^2+x+1$$   what is the remainder of $P(x)$ divided by $Q(x)$?     The given answer was:     Let $Q(x)=0$. Multiplying both sides by $x-1$:   $$(x-1)(x^4+x^3+x^2+x+1)=0 \implies x^5 - 1=0 \implies x^5 = 1$$   Substituting $x^5=1$ in $P(x)$ gives $x^4+x^3+x^2+x+1$. Thus,   $$P(x)\equiv\mathbf0\pmod{Q(x)}$$     Obviously, a student is required to come up with a “trick” rather than doing brute force polynomial division. How is the student supposed to think of the suggested method? Is it obvious? How else could one approach the problem? Turn off text message (SMS) sync to Exchange email account I recently started using a Samsung Galaxy S4 and one of the features in a synchronization between text messages and email accounts.  When a text message comes in it throws a copy into my Exchange email accounts that are one the phone. I want to turn this feature off but cannot find a setting for it anywhere.  Any ideas? $ {L}_{1} $ Regularized Unconstrained Optimization Problem