When chinese word in mysql where statement
What is the difference between varchar and nvarchar?
Is there a password manager for Ubuntu What is the most popular open source password manager which I can use on a Ubuntu machine or preferably across Ubuntu/Windows machines with some form of data compatibility. If there is a free web based version, that would be even more preferable. I'd like to copy files from one external drive to a network connected drive. I want to make sure that there are no errors.  I know of MD5 hash files that I see for large single files that are download from the internet. I also know that I can use the terminal to 'diff' the two sets of files.  However, I'm looking for a piece of software that could confirm that all the files in the file structure have been copied by the finder completely, or a piece of software that would do the copying for me and confirm that all the bits are exactly the same.  The files are video related - and are often over a TB in size (not in one file - complex multi-folder nested files)  I'm fine if there is a terminal command that can do the copy and compare for me as well. (although being able to see the amount of time left on a copy is a very nice feature... additionally, I want to make sure I get ALL of the file - resource forks and all) Why can't I log into minecraft with a mojang account? 'Possible duplicate' comment not appearing for questions with deleted comments containing the link I posted a comment to a duplicate question on . But I decided to delete it. Afterwards I voted as duplicate and thought a comment would be generated like     possible duplicate of ...   But it didn't. My guess is that the duplicate-comment won't be generated if a comment exists with that link, even if deleted. I have a Dell Studio 17. It's a few years old, and I wanted to upgrade the processor. It currently has an Intel Core 2 Duo T5750 @ 2.00GHz  My question is how can I find out which processors are compatible? How to read the following Itinerary What do the abbreviations mean in the following itinerary:     2  EK 641 L 29NOV 2 KBLDXB HK1       I  1630 1905   *1A/E*                      3  EK 344 L 29NOV 2 DXBKUL HK1       3  2140 0835+1 *1A/E*                      4  MH 704 V 30NOV 3 KULMNL HK1       M  1245 1630   *1A/E*                      5  UA 184 Y 01DEC 4 MNLGUM HK1       1  2255 0440+1 *1A/E*                      6  UA 155 Y 02DEC 5 GUMTKK HK1          0820 1008   especially, the numbers (2,2,3,4,5) before KBLDXB, KULMNL.... The letters and numbers before time (I, 3, M, 1) *1A/E*? Affiliate Ads Are Coming To The Network Some time ago, we announced that . This has gone well and we're extremely thankful to everyone for their support and feedback. Because it has been successful so far, we're going to be extending the program to the majority of our graduated sites. Well, we've pretty much already done that, but there are quite a few sites that have ads enabled, yet still display nothing. The thing is, we don't really have an abundance of clients offering products that a  would find relevant, but Amazon has stand mixers, a selection of super fine chinois, deliciously sharp cutlery and enough cast iron to fill the Gulf Of Mexico with . Beginning as early as this week (week of 5 February 2018), our ad team is going to be hand selecting affiliate ads to be displayed on select sites. The use of inventory will of course depend on the availability of relevant ads to display which means:  Some sites might see very few, if any ads. Some topics simply don't come remotely close to orbiting anything worth advertising. Furthermore, while graduated, some sites simply don't have enough activity for ads to make sense.  Since these are hand-selected, it could take a while for ads to appear initially.  These would of course yield to inventory from clients if clients had products that were relevant to any given topic.   Nothing changes when it comes to the . If you're used to occasionally seeing a community promotion ad, you'll just notice that you'll also occasionally see an ad for something that is likely to be of interest to someone interested in the topic that your site covers. In fact, to be clear, this is simply a continuation of the announcement we made in November of 2016. We just wanted folks to know that we're going to be continuing the program where there's good potential to show relevant advertisements, even if we don't have clients lined up with a demand for it. Where can I give feedback about a certain ad on [site]? Open a meta post on your per-site meta and let us know. Please remember, the bulk of advertisements are an effort to get something small back from folks that hit the sites through search engines and are extremely unlikely to ever become contributors. Their soufflé stopped falling, and we'll probably never see them again. Maybe we can get a few bucks once they realized that copper ions help egg whites stiffen properly and buy a bowl or a proper bloom whisk. However, you're the experts on these topics and we're very likely going to listen to you. What sites, specifically? Are any sites exempt? If you're a former Stack Exchange 1.0 site and / or subsequently joined the network under a special charter, nothing changes - don't panic :) For the rest, we're just extending what we're currently doing with ads on graduated sites to also include those where there's an opportunity to make sensible use of affiliate ads. If a site has less than 15k (average) daily visits, or fewer than roughly 50k combined total posts - it might not yet be time to invest in selecting ads to be shown there. But, part of this exercise is also seeing what works best. I don't really have feedback, just some suggestions Ads aren't just an opportunity to sell stuff, they're an opportunity to really show people that we understand a given topic. That, of course, makes suggestions from people that do that stuff every day quite valuable. Post on your per-site meta and our community / ad critters will take a look. Questions? Comments? Kvetches? Let us know in an answer or comment below. If anything about the plan changes, we'll update this post to let folks know. Related to Meta Super User efforts:  and Meta Server Fault efforts:  We already auto-remove negatively voted unanswered old questions automatically after 30 days, network wide, with no human intervention required. I was thinking we might extend that to remove old, unanswered zero score questions... based on the following criteria:  fewer than (question age in days * 1.5) views 0 score or lower, or 1 score or lower if the original author is deleted no answers 1 comment or fewer asked more than 1 year ago (thus based on creation date, not last activity date, so , or a user editing it, does not give a doomed question 365 more days of zombie &quot;life&quot;)  See the results of this query on:  (10509) |  (787) |  (650) This query has been refined based on the comments, and this is the final version that will roll out tonight. Every site in the network (except metas) will automatically delete old questions that meet this criteria from this point forward. Present perfect for past action with present effect If I seem tired, can I say: "I haven't slept last night"? If not, why have I been told that we use present perfect for actions that have present effects? Transparency/Masking : See through an Outer Sphere and see Inner Sphere in true colours Summary  I want to be able to look through an outer sphere - BlueSphere, and see another sphere inside - RedSphere  This is the target goal I'm trying to get to:    Issues  Here is what I have tried, and the problems I'm having:  1)  If I set the spheres transparency alpha values to 0.75    - then the inner RedSphere does not take on its "true" colour and shows as blue instead of red.    2)  If I set the spheres transparency alpha to lower values of 0.5   the spheres lose their crispness which I don't want and the inner RedSphere still does not take on its "true" colour   { can't paste a 3rd sample - need more reputation points }   Background  I am animating two spheres, one inside the other, superimposed about a common origin.   At the start:   the outer BlueSphere is at full radius the inner RedSphere is at zero radius  As time progresses:   the outer BlueSphere shrinks the inner RedSphere expands    So what happens is the expanding inner RedSphere "bursts through" the contracting outer BlueSphere.  So the effect I am looking for is to see the RedSphere appearing as Red as it expands inside the BlueSphere.  Thinking/Logic  So I figure that transparency is not the way to go.  The transparency settings are behaving correctly - as one would expect, in a "real world" situation - the inner sphere (Red) takes on the colour of the outer sphere (Blue) seeing as we are looking through a (transparent) Blue material.  Any ideas on what approach to take ?  It's almost as if I should be "removing" the part of the BlueSphere that the RedSphere "occupies" so that we see the RedSphere directly without any BlueSphere between us and the RedSphere.  Some sort of masking ??  Advice, comments, suggestions welcome. Thanks.  [requested edit]  Using internal render.  [ My End Solution - Thanks for the guidance ]  Right, so here is the way I got to my final result:  1) I created python drivers for each sphere   I used the frame_current scene property for input Passed that to a scripted expression which used sin() as the scaling factor Used some if / elif conditionals against frame_current to make the spheres visible only when I needed them   2) I created 3 layers   On Layer-1 - background   I put RedSphere AND BlueSphere with drivers driver_Outer_RedSphere() &amp; driver_Outer_BlueSphere() limiting the display of each sphere to show only where each radius > halfway  On Layer-2 - foreground-1   I put RedSphere ONLY with driver driver_Inner_RedSphere() limiting the display of RedSphere to show only where its radius &lt;= halfway  On Layer-3 - foreground-2   I put BlueSphere ONLY with driver driver_Inner_BlueSphere() limiting the display of BlueSphere to show only where its radius &lt;= halfway    3) I rendered each layer to .PNG sequence [RGBA] (alpha channel for transparency)   Render Layer-1 - background   background : [sky]  Render Layer-2 - foreground-1   background : [transparent]  Render Layer-3 - foreground-2   background : [transparent]    4) I brought all 3 sequences into the Video Sequence Editor   Strip-1 - background   blend [cross] opacity [1.00]  Strip-2 - foreground-1   blend [alpha-over] opacity [0.50]  Strip-3 - foreground-2   blend [alpha-over] opacity [0.50]    5) Rendered the 3 layer final sequence to H.264  So the "aha moment" struck me right at the end when I was in the Video Sequence Editor:   "Don't try to make the Outer Spheres transparent, and see through to the Inner Spheres" "Instead overlay the Inner Spheres over the Outer Spheres, and limit the opacity of the Inner Sphere overlay"     So now I see my Inner Spheres in their true colours, but the colours are muted due to the .75 opacity - and hence it gives the visual impression that the Inner Spheres are in fact inside the Outer Spheres.  Thanks all for the input - it got me going in the right direction. There are several distinct usages:   kernel density estimation   kernel trick   kernel smoothing   Please explain what the "kernel" in them means, in plain English, in your own words. How do you judge the quality of a journal? Why are light rays able to cross each other? See the image first:   Why are light rays able to cross each other? Air isn't able to. My Bridgestone MB-5 currently has a 7-speed rear wheel. I'd like to convert it to a 10-speed. Is this possible? Is it practical? Where do I get a SIS mirage 672 vga driver? Many times I have read statements like, "the age of the universe is 14 billion years" . For example this wikipedia page .   Now, my question is, which observers' are these time intervals? According to whom 14 billion years? How do spell lists change if the party levels up without taking a long rest? I'm playing in a D&amp;D 5e campaign with a bard and a wizard.  Our most recent session ended while we were in the middle of exploring a dungeon. The DM informed us that we leveled up from 4 to 5.  The wizard and bard were excited to get level 3 spell slots for the first time. They began discussing the level 3 spells they were looking forward to casting at the beginning of the next session. I asked, "Don't you guys need to have a long rest before you can cast new spells, though?"  The bard argued that he doesn't need a long rest, because he learns spells immediately upon leveling up and doesn't need to prepare them.  The wizard argued his "number of spells available" count increased immediately upon leveling up, and it wouldn't make much sense if his actual number of prepared spells stayed the same.  Ultimately, the DM decided that it would be more fun if everyone got access to their new toys at the same time. He permitted the wizard to add a level 3 spell to his prepared spell list.  Who is right? Do bards (and other casters that do not prepare spells) get access to new spells more immediately than wizards (and other casters that prepare spells)?  I looked at , but "Can a mage use his newly gained 2nd-level spell slot?" seems like a separate matter from "Can a mage use a newly gained spell?". System Load Indicator only shows as a line unless hovered I installed the  GNOME extension on my Ubuntu 18.04, but for some reason, instead of showing a proper graph for CPU usage, it only shows a very thin line that seems to be a small portion of the actual graph. If I hover over it, the proper graph shows. How to make it show the whole graph all the time? Not flying the first leg of the journey – Company cancels the second-leg ticket I've a friend that booked a round-trip journey. He booked A-to-B and B-to-A. Somehow he needed to be earlier at location B, so he took a train and did not take the flight from A to B.  When he went to the airport to take the "back home" flight (B-to-A), he was informed that his ticket was canceled because he did not take the A-to-B flight. They canceled the ticket and sold it to someone else.  Is this normal? The company said it was their right to do so, and he could not get the flight back. The company was Iberia. Converting vector layer to raster using QGIS? In qgis in the raster menu there is an item "convert vector to raster".  This behaves strangely - I do not understand how it is supposed to work.  I can select a vector file, an attribute and an output raster. But, for some reason the output file is only accepted if it exists and even if I select an existing raster nothing seems to happen.  Also I do not understand how the program knows what kind of raster to create, what cell-size, projection etc.  How can I convert vector to raster?