Home > IT Blogs > SQL Server with Mr. Denny

SQL Server with Mr. Denny:

Reporting

November 28, 2007  7:38 AM

What’s up with the N in front of string values?

Denny Cherry Denny Cherry Profile: Denny Cherry
DNS, Firewalls, Migration, Reporting

If you have looked at pretty much any Microsoft provided T/SQL code you have probably seen an N in front of a string value when setting a variable much like this. SELECT * FROM...

0 Comments     RSS Feed     Email a friend

November 26, 2007  7:35 AM

Should I be using uni-code data types?

Denny Cherry Denny Cherry Profile: Denny Cherry
DNS, Firewalls, Reporting, Wireless

The path that Microsoft is going says yes.  They are moving all there samples and defaults to using uni-code.  In reality uni-code may not be needed in your environment.  If you are storing only Latin characters (the US alphabet characters) then you probably don't need to store uni-code...

0 Comments     RSS Feed     Email a friend

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: