Solved

sql server and russian characters

Posted on 2011-09-28
5
355 Views
Last Modified: 2012-05-12
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
Comment
Question by:Soluga
  • 2
  • 2
5 Comments
 
LVL 25

Accepted Solution

by:
TempDBA earned 250 total points
Comment Utility
There shouldn't be. But still m not fully confident. Anyone?
0
 
LVL 7

Assisted Solution

by:mozcullu
mozcullu earned 250 total points
Comment Utility
nvarchar(250) is a better alternative compared to ntext. I see no other options.
0
 
LVL 1

Author Closing Comment

by:Soluga
Comment Utility
I didn't think so, but thought it was worth a punt.

incidently why is nvarchar better than ntext?

Thanks
0
 
LVL 7

Expert Comment

by:mozcullu
Comment Utility
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
 
LVL 1

Author Comment

by:Soluga
Comment Utility
That great clarification.

Cheers
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now