如何在asp.net中将nvarchar转换为varchar [英] how to convert nvarchar into varchar in asp.net

问题描述

如何将nvarchar转换为varchar ????

How to convert nvarchar into varchar????

推荐答案

您不需要做任何事情，因为两者都是字符串表示为 String Char [] 。

请参阅 SQL Server数据类型映射 [ ^ ]。

You don''t need to do anything since both are string represented as String Char[].
See SQL Server Data Type Mappings[^].

正如Abhinav所说，你不需要做任何事，但你需要知道它们是不同的：



NVarChar （字符串） Unicode字符的可变长度流，范围在1到4,000个字符之间。如果字符串大于4,000个字符，则隐式转换将失败。使用长度超过4,000个字符的字符串时，请明确设置对象。当数据库列为nvarchar（max）时使用NVarChar。



VarChar （String）可变长度< u> 非Unicode字符的流，范围在1到8,000个字符。当数据库列为varchar（max）时使用VarChar。

As Abhinav mentioned you don''t need to do anything, but you need to know that they are differ:

NVarChar (String) A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. Implicit conversion fails if the string is greater than 4,000 characters. Explicitly set the object when working with strings longer than 4,000 characters. Use NVarChar when the database column is nvarchar(max).

VarChar (String) A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters. Use VarChar when the database column is varchar(max).

这篇关于如何在asp.net中将nvarchar转换为varchar的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！