Solved

how can i identify this character or reproduce it?

Posted on 2014-10-23
3
116 Views
Last Modified: 2014-10-24
below is a record in the results window pane in sql server management studio.

notice the arrow character
notice in the picture above the "arrow" character pointing to the right between "BP" and "Remaining". this field is type varchar(1024). if I copy this field in the results pane and paste it into the query pane above, I get the following:

notice the box character
notice how the "arrow" character is now a box with what looks like a question mark without the dot.

my question is how can I find out what character this is and how I can reproduce it. I can certainly query the table for this by using the where statement below:

notice i retain the square character
anybody have a clue? please ask if you have questions and I will clarify the best I can. the text editor font is consolas. I can change the font but that's doesn't help as when I change it to courier, it displays as a square box.
0
Comment
Question by:Bryon_connexus
[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
3 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40400634
Declare @char varchar(100) = 'copy-paste your string here'
SELECT ASCII(SUBSTRING(@char, 11, 1))

Then google 'ASCII Character Set' and look up what that character translates to.

btw if you are in hell with all of these characters I highly (HIGH - LEE) recommend downloading a trial of UltraEdit, where you can open any file, do a Ctrl-H, and look at the Hex value of every character.  There are other text editors-on-steroids apps out there, but this is the one I'm familiar with.
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40400635
can you do this:

select ascii(substring(column_name, 11, 1)) from table_name where column_name like '%BP%Remaining%' 

Open in new window


it should get the ascii code of that character and then you can query it..

YOu can use this site to lookup for codes or representation of those codes  http://www.lookuptables.com/
0
 

Author Closing Comment

by:Bryon_connexus
ID: 40402850
the early bird gets the worm. Jim was the first to answer correctly.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

705 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