<div>
I didn't think so, but thought it was worth a punt.<br />
<br />
incidently why is nvarchar better than ntext?<br />
<br />
Thanks
</div>


I didn't think so, but thought it was worth a punt.

incidently why is nvarchar better than ntext?

Thanks

<div>
reasons why varchar is a better choice:<br />
<br />
1. text is old data type and will be removed in later versions. varchar(max) should be used for replacing it.<br />
2. text will consume more space on your database compared to a limited varchar<br />
3. the behaviour of SQL Server is different for text fileld and this may have influence on your performance.<br />

</div>


reasons why varchar is a better choice:

1. text is old data type and will be removed in later versions. varchar(max) should be used for replacing it.
2. text will consume more space on your database compared to a limited varchar
3. the behaviour of SQL Server is different for text fileld and this may have influence on your performance.


<div>
That great clarification. <br />
<br />
Cheers
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
My asp application was designed for uni set characters to be stored in the database. Many fields are varchar(250). Is there anyway to store russian characters in the table field without changing the the field type to ntext?<br />
<br />
Thanks 
</div>
</div>


Hi,
My asp application was designed for uni set characters to be stored in the database. Many fields are varchar(250). Is there anyway to store russian characters in the table field without changing the the field type to ntext?

Thanks 

sql server and russian characters

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.