?
Solved

Tab Character gets saved as a box character in SQL 2005

Posted on 2007-04-03
7
Medium Priority
?
196 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
[X]
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
  • 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 750 total points
ID: 18848915
you might want to replace the tab character  - char(9) - by a space:
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

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

AWS Certified Solutions Architect - Associate

This course has been developed to provide you with the requisite knowledge to not only pass the AWS CSA certification exam but also gain the hands-on experience required to become a qualified AWS Solutions architect working in a real-world environment.

Question has a verified solution.

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

Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

770 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