asked on

Tab Character gets saved as a box character in SQL 2005

I collectiong data on an aspx page. I need to be able to detect and delete "tab" character. It gets saved in my sql 2005 database as a "box" character.
This is an example:
• Created business process models using IBM WebSphere Business Integration Modeler
•      Facilitated interviews and research of corporate artifacts to understand current business processes
•      Developed and implemented “QuickPlace,” an online system to increase team communication and collaboration
•      Oversaw project team and asset transactions

Guy Hengel [angelIII / a3]

how do you "see" that "box" character? if you see that in the query result in management studio, don't care. rather, get the results to a normal text editor, and you will see the tab will be displayed normally.

mattphung

ASKER

I am writing data to a pdf file using componentOne dll. It gets confuse when it encounters the BOX character. I don't kow how to prevent it from being saved to the database. I think what the users are doing is copying a bullet list from MS Word and pasting it in the textbox.

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mattphung

ASKER

Do you know the ascii code for the first character of this bullet list?
• Tst
• test
this was done in ms word

Guy Hengel [angelIII / a3]

select ascii('•')
returns for me:
149

but, that could be different for other bullets...

mattphung

ASKER

Can you tell me how you found out the ascii code?

Guy Hengel [angelIII / a3]

by running the sql query:
select ascii('•')