DotNet Snippets^1.0

In a MS SQL database have you ever wondered what the difference between ntext and text is or nvarchar and varchar? The n in front basically means those data types will support international characters. So if you've ever tried saving funky characters to the database and can't figure out why they come out as question marks, even you have your collection right, that is why.

Here is an interesting article that is worth reading, it is platform agnostic btw. http://joelonsoftware.com/articles/Unicode.html

• Comments / Show

Very easy to change a database name in sql server, but it must be done via a sql command

 —-Create db for test
CREATE DATABASE Test
GO
    —-Rename the Database Test
ALTER DATABASE Test MODIFY NAME = "New Test"
GO

• Comments / Show