• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

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


 
0
mattphung
Asked:
mattphung
  • 4
  • 3
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
 
mattphungAuthor Commented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you might want to replace the tab character  - char(9) - by a space:
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
mattphungAuthor Commented:
Do you know the ascii code for the first character of this bullet list?
•      Tst
•      test
this was done in ms word
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
select ascii('•')
returns for me:
149

but, that could be different for other bullets...
0
 
mattphungAuthor Commented:
Can you tell me how you found out the ascii code?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
by running the sql query:
select ascii('•')
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now