Solved

sql server and russian characters

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

Assisted Solution

by:mozcullu
mozcullu earned 250 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
This query failed in sql 2014 5 33
Html fieldset fix its height and width 4 34
MS SQL Server select from Sub Table 14 27
IIS 7 and executing pages using localhost 16 14
Introduction Knockoutjs (Knockout) is a JavaScript framework (Model View ViewModel or MVVM framework).   The main ideology behind Knockout is to control from JavaScript how a page looks whilst creating an engaging user experience in the least …
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

820 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