Solved

Tab Character gets saved as a box character in SQL 2005

Posted on 2007-04-03
7
168 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 142

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 142

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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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 142

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 142

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

"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

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

23 Experts available now in Live!

Get 1:1 Help Now