Actually, you absolutely cannot legally change the locks, 'kick someone out', or force them to move without notice. As your name is on the lease, you are technically this person's landlord, and therefore are bound by the same landlord/tenant rules that all landlords are. If this person is 'staying with you' and has been there for more than 30 days, you are out of options except to take him to court as a landlord/tenant dispute. If you change the locks, in most states you can be sued, and forced to pay up to 3 times his rent and moving expenses for punitive damages.
NVARCHAR â Data is stored in a Unicode encoding. Every language is supported. A Good Idea. What about storage space? VARCHAR is generally efficient, since the character set / encoding was custom-designed for a specific locale. NVARCHAR fields store either in UTF-8 or UTF-16 encoding, base on the NLS setting ironically enough.
If your column will store a fixed-length Unicode characters like French, Arabic and so on characters then go for NCHAR. If the data stored in a column is Unicode and can vary in length, then go for NVARCHAR. Querying to NCHAR or NVARCHAR is a bit slower then CHAR or VARCHAR. So don't go for NCHAR or NVARCHAR to store non-Unicode characters even though this data type supports that.