Solved

sql server and russian characters

Posted on 2011-09-28
5
356 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql join/ assign small # first 10 83
Restrict result set 1 34
Microsoft SQL ADO Conn Issue 6 39
MS SQL - Rotating Values in SQL 9 50
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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)
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

911 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

22 Experts available now in Live!

Get 1:1 Help Now