Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Tab Character gets saved as a box character in SQL 2005

Posted on 2007-04-03
7
175 Views
Last Modified: 2013-11-19
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


 
0
Comment
Question by:mattphung
  • 4
  • 3
7 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18848821
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.
0
 

Author Comment

by:mattphung
ID: 18848834
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.
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 18848915
you might want to replace the tab character  - char(9) - by a space:
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:mattphung
ID: 18848926
Do you know the ascii code for the first character of this bullet list?
•      Tst
•      test
this was done in ms word
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18848937
select ascii('•')
returns for me:
149

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

Author Comment

by:mattphung
ID: 18849003
Can you tell me how you found out the ascii code?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18849024
by running the sql query:
select ascii('•')
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

840 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