• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

sql server and russian characters

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
0
Soluga
Asked:
Soluga
  • 2
  • 2
2 Solutions
 
TempDBACommented:
There shouldn't be. But still m not fully confident. Anyone?
0
 
mozculluCommented:
nvarchar(250) is a better alternative compared to ntext. I see no other options.
0
 
SolugaAuthor Commented:
I didn't think so, but thought it was worth a punt.

incidently why is nvarchar better than ntext?

Thanks
0
 
mozculluCommented:
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.
0
 
SolugaAuthor Commented:
That great clarification.

Cheers
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now