Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sql server and russian characters

Posted on 2011-09-28
5
Medium Priority
?
367 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 1000 total points
ID: 36716145
There shouldn't be. But still m not fully confident. Anyone?
0
 
LVL 7

Assisted Solution

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

Author Closing Comment

by:Soluga
ID: 36716195
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
ID: 36716268
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
ID: 36716316
That great clarification.

Cheers
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
The viewer will learn how to count occurrences of each item in an array.

824 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