I have a Table with three columns :
MessageID (int)
MessageText (ntext)
ChannelID (int)
Now i want to get the list of message IDs where the message Text Contains some Special characters as like the characters from the below image. how to query to get the list of message ids where the message text contains any one of this special characters.
I am working on writing some code to scrub user input to my ASP.NET site. I need to scrub input to remove all references to ASCII characters 145, 146, 147, 148 which are occasionally getting input from my mac users who are copying and pasting content they write in a word processor on their macs.
My issue is the following three strings I am led to believe should output the same text.
string test1 = Convert.ToChar(147).ToString();
string test2 = String.Format("'{0}'", Convert.ToChar(147));
char[] characters = System.Text.Encoding.ASCII.GetChars(new byte[] { 147 });
string test3 = new string(characters);
Yet when I set an ASP TextBox to equal the following
txtShowValues.Text = test1 + "*" + test2 + "*" + test3;
I get a blank value for test1, test2 works correctly, and test3 outputs as a '?'.
Can someone explain what is happening differently. I am hoping this will help me understand how .NET is using ASCII values for characters over 128 so that I can write a good scrubbing script.
EDIT
The values I mentioned (145 - 148) are curly quotes. So single left, single right, double left, double right.
By "works correctly" I mean it outputs a curly quote to my browser.
SECOND EDIT
The following code (mentioned in an answer) outputs the curly quotes as well. So maybe the problem was using ASCII in test 3.
char[] characters2 = System.Text.Encoding.Default.GetChars(new byte[] { 147 });
string test4 = new string(characters2);
THIRD EDIT
I found a mac that I could borrow and was able to duplicate the problem. When I copy and paste text that has quote symbols in them from Word into my web app on the mac it pastes curly quotes (147 and 148). When I hit save curly quotes are saved to the database, so I will use the code you all helped me with to scrub that content.
FOUTH EDIT
Spent some time writing more sample code based on the responses here and noticed it has something to do with MultiLine TextBoxes in ASP.NET. There was good info here, so I decided to just start a new question: http://stackoverflow.com/questions/2215547/asp-net-multiline-textbox-allowing-input-above-utf-8
I will have my string as follows
String S="AB-1233-444";
From this i would like to separate AB and would like to find out the ASCII for that 2 alphabets.
Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.
Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.
I have addded some different languages into database table column(NText), then im retrieving the data and display it on the Dropdownlist and Gridview but some of the languages(like Korea, Japan) displays as boxes.
View 12 RepliesI have a table with 2 columns that lookes something like this:
ChapterID | VersionNumber | VersionID |
1001 | 1 | 1004 |
1001 | 2 | 1005 |
1002 | 1 | 1006 |
1002 | 2 | 1007 |
1002 | 3 | 1008 |
1003 | 1 | 1009 |
1004 | 1 | 1010 |
what I wanna achieve is to have a statement that selects distinct uniqueid's from the chapterID field and with every duplicate I would like to have the record with the highest version number
Below is the result I would like to achieve:
ChapterID | VersionNumber | VersionID |
1001 | 2 | 1005 |
1002 | 3 | 1008 |
1003 | 1 | 1009 |
1004 | 1 | 1010 |
I have tried this statement:
Select Distinct ChapterID, max(VersionNumber) from Versions groupby ChapterID
and it works fine, but when I add the VersionID column like so:
Select Distinct ChapterID, VersionID, max(VersionNumber) from Versions group by ChapterID
it returns an error.
I want to select the list of messagetext from the messages table where the message text contains any of the Carriage Return Characters?? (Eg: /r/n) what are the other Carriage Returns characters and how can i filter those from the message text?
View 8 RepliesI am listing details using a gridview and wish to just display the first 50 characters of a 1000 character field. I feel this should be simple but cannot find the solution.
My current gridview code for this field is simply
<asp:BoundField DataField="BullDetail" HeaderText="Details" />
i have the below query where MessageText column is of ntext datatype..whe n i run the below query it is giving me the below error. Error :The data types ntext and varchar are incompatible in the add operator.
select li.LookUpPageInfoId,
li.PageMessageID,
li.PathMessageID,
li.IsActive,
m.MessageID,
(select messagetext from messages where messageid=pagemessageid and channelid=m.ChannelID)+'/'+
m.MessageText as TotalText,
m.ChannelID
from
LookUpPageInfo as li left outer join
Messages as m on m.MessageID=li.PathMessageID and li.IsActive=1
Can some one suggest me how to concatenate the ntext column....but the above works good if the column MessageText is of nvarchar(max) datatype.
A variety of files (pdf, images, etc.) are stored in a ntext field on a MS SQL Server. I am not sure what type is in this field, other than it shows question marks and undefined characters, I am assuming they are binary type.
The script is supposed to iterate through the rows and extract and save these files to a temp directory. "filename" and "contenttype" are given, and "data" is whatever is in the ntext field.
[code].....
This works, but the file should be saving to the server instead of popping up save-as dialog. I am not sure if there is a way to save the response to file.
So I have a ntext column in a table with a combination of large random data (hence why ntext in the first place) and sometimes contains a uniqueidentifier.
I need to find and delete rows based on the uniqueidentifier.
I can't do the comparison with it being ntext, but I changed it to varchar(max) in my dev enviornment and it let me do it without any warnings and I can now do my comparison like I want to, so all is good.
I just want to make sure I'm not changing any of my large random data by changing the data type.
I have a bit of code in a clickevent handler like this:-
Dim products = From p In db.Products where p.product_name = "Tool" Select New With {p.Product_ID,p.Product_name}
Gridview1.Datasource = products
GridView1.Databind()
But causes error=SQL Server does not handle comparison of NText, Text, Xml, or Image data types?
where product_name field is set as type text
I am writting a custom class with which I manipulate the data for my website. I was wondering if there is a way to connect to a database and retreive the column names for a given table with out sellecting any data in the table.
Currently I am using an sql select and connection string to create an SqlComman object. Then I use the command object to create a SqlDataAdapter object which I use to fill a DataSet. At the end of all that I am able to retrieve the column names but I have select data and retreived data.
I use this query for my table but it retrives the value for each row. It does not retrieve the size of the column name. I need to know the number of characters occupied in particular column. How do i get this value?
SELECT LEN(salary) AS MyLength FROM employee
I have gridview and button and radiobutton in page below are codes...
<input type="radio" name="n" id="RBmkvM" runat="server"/>
<input type="radio" name="n" id="RBdvdM" runat="server"/>
<asp:ImageButton ID="ImageButton1" runat="server" CssClass="imgored" ImageUrl="~/Image/Main/png1.png" OnClick="Imgorder_Click"></asp:ImageButton>
[Code]....
I have one requirement i.e i wanted to replace or remove all the special characters except alphanumeric in the column value
how to do ....
need to get selected value from dropdownlist,textbox and bind in grid
View 1 RepliesI have a grid view control with Template Field containing Item Template as Checkbox control and the Header Template is containing the label with column header name.
I want to click the coulmn header label and all the check boxes must be checked once.
provide me some examples or ideas how i can achieve this
[code]....
I have a column in my repeater which allows as many as 255 characters and causes the page contents pushed away to the right if any of the record has all 255 characters in that column. How can I tell it to wrap the text after 50 characters?
View 4 RepliesI have a form where i want to view all columns from a table.I have a textbox and differeent radio button having values of each column.On click of button.I want to view all the columns as per selected row/rows from value given
View 1 RepliesI am having trouble with this statement
[Code]....
I only want the record with the highest value in the EarnedPoints Column, but I get the error
Column 'customer_locations.City' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
I am trying to display the total points Earned, the Client Name, City and State.
,What does the [0] in this code stand for ?I know the line gets the number of bytes in the ASCII characters, if its less than 91 and greater than 64.But why the [0] string str = strs[i];
if (Encoding.ASCII.GetBytes(str)[0] <= 64 || Encoding.ASCII.GetBytes(str)[0] >= 91)
{
Console.WriteLine(Encoding.ASCII.GetBytes(str)[0].ToString());
}
else if (Encoding.ASCII.GetBytes(str)[0] != 88)
{
Console.WriteLine(str);
}
In .net streams are by default encoded in utf-8. so what i want to do is to simply read the text in a textbox in which i paste the russian characters and then convert them to ascii. but when i debug the code then in my resulting string ? appears. how i can convert the string into its ascii equivalent. my code is given below
string inputString = txtName.Text;
ASCIIEncoding ascii = new ASCIIEncoding();
Encoding encoder = ASCIIEncoding.GetEncoding("us-ascii", new EncoderReplacementFallback(string.Empty), new DecoderExceptionFallback());
byte[] bAsciiString = encoder.GetBytes(inputString);
string cleanString = ascii.GetString(bAsciiString);
Possible Duplicate:
Are there any disadvantages to always using nvarchar(MAX)?
Is there a general downside by chosing 'ntext' as column type instead of a type that contains chars but with a limited max size like 'char' or 'varchar'?
I'm not sure whether a limited column size is applyable to all my colums. Therefore I would use 'ntext' for all columns containing text. Might this lead to problems in the future?
(I'm using Linq-To-SQL in a ASP.net Webforms application)
I am using this code to find titles depending on user criteria:
[Code]....
The search is non-english charachters, and it has some problems. when you looks for "Marker" and in database you have this title: "Markers" it won't find it..... This search just not good enough and I am looking to replace it urgently....