English 中文(简体)
在2008年板球服务器上刊登故事?
原标题:Storing stories in sql server 2008?

我将储存服务器的Nvarchar(TM)油田的故事,但我知道,故事会比Lex允许的要长得多,因此我应当采取什么做法? 我是否应该把故事分成多行,或者我是否应该利用数据库并利用文字档案?

最佳回答

我认为,造成混淆的原因是对这里术语的误解。

<代码>nvarchar(n)为数据类型,n可以是1-4000。 The number n in this case has amax of 4000, which increase up to 8000 bytes (2 bytes per nature).

。 a 上文实例中<代码>n任何潜在价值的同义词。 这类领域最长为2^31-1级,即10亿以上,增加了20亿以上的特质(2个特质)。

同样的原则适用于<代码>varchar(n)和varchar(import),但每一特性may仅限1 byte,在这种情况下,可以储存的特性数目为两倍。 是否只有1条依靠核对,如:。 评论中的注释!

问题回答

Store them in chapters.

这不是技术性的,因此很难掌握10亿英亩的特性(Nvarchar(max)是“新的”大气数据类型。

直接装货和处理这些货物将是痛苦的。

将它们作为章节存放,在每一章的起始/终端页数,如果是有意义的的话,那么你就能够稍加容易浏览。

Btw., you posted you thought it is 800 chars - that was NEVER trhe case. The limit would be 8000 bytes - if it would apply - and that would be 4000 chars unicode.





相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签