Solved

how can i identify this character or reproduce it?

Posted on 2014-10-23
3
103 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
3 Comments
 
LVL 65

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

707 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

11 Experts available now in Live!

Get 1:1 Help Now