本文讨论了在存储HTML内容时，选择ASCII还是Unicode（NVARCHAR）的问题。作者指出，基本HTML模板可以使用VARCHAR，但如果有包含多种语言的内容，则需要NVARCHAR，因为它支持Unicode，可能会使存储空间加倍。考虑到Unicode的普遍使用，现在作者通常倾向于使用NVARCHAR。决定因素取决于具体应用场景。
VARCHAR(MAX) if it's all going to be ascii-based, say for basic HTML tepmplates
NVARCHAR(MAX) if the HTML could contain any content
NVARCHAR will double your storage use as it uses double the amount of space as VARCHAR. HTML itself does not require NVARCHAR, only the content in-between the HTML tags could based on the language, etc..
Edit:
Many years on from giving this answer I almost always use NVARCHAR now if there is any between the tag content. Unicode is popular...
I only use VARCHAR if just storing simple html templates, eg tags and placeholders
eg:
[PLACEHOLDER]
Make the call based on your use-case..
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
