Solved

how can i identify this character or reproduce it?

Posted on 2014-10-23
3
112 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql help 8 58
Master DB with Masterkey 1 34
Negative isnull? 3 15
How can I get the entire database script? 7 14
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

830 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