I am doing my first database project in PostgreSQL or Oracle.
I would like to get an answer for my question.
+2
A:
there's no string in database. string in .net is limited only by memory. there's no such thing as nvarchar(5000). you can have nvarchar(4000) or nvarchar(max) 4000 is the max char length you can store and one char is store in 2 bytes. you can read more about this in Books Online
Mladen Prajdic
2009-07-28 20:09:00
to add to this, nvarchar stores the data in "national" unicode, whereas a varchar uses the database defined encoding and is generally half the size to store
curtisk
2009-07-28 20:15:44
@curtisk: Which one does SO use?
Masi
2009-07-28 20:19:28
@Masi: You might be interested in "What was Stack Overflow built with?" http://blog.stackoverflow.com/2008/09/what-was-stack-overflow-built-with/
Greg Hewgill
2009-07-28 20:28:40