• 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
 
Metehan OzculluSQL Service ManagerCommented:
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
 
Metehan OzculluSQL Service ManagerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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