[HELP] Custom Normalization

Question

User-1679863939 posted

Hi, everyone.

I'm developing a web site which sends information to the sql server. Though column's property in the sql server is set to "varchar", it accepts any type of characters (but returns only eng chars). I need to prevent inserting any characters but english ones from, let's say a textbox, to the sql server.

I don't want to type an exception for every foreign char:

if (textbox1.text.contains("й")) ....

Is there any way to make asp.net BLOCK all chars except (list) instead of ALLOW all chars except (list) ?

Or maybe an easier way to prevent foreign chars  =)

P.S. i'm coding in C# but i'll be thankful for VB answer too. 

Answer 1

User1416329745 posted

What you are looking for is called collation precedence, it can get tedious but most of what you need is covered in the links below.  The first for SQL Server 2005 and the second for SQL Server 2000.  Hope this helps.

http://msdn.microsoft.com/en-us/library/ms179886.aspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7ory.asp

Answer 2

User-1679863939 posted
Thank you, Caddre, ^_^ That's the way to block unwanted chars in sql tables. It was very useful and solved my problem. By the way, i still wonder if there's any way to do it on web server-side?