2

Somebody left this special character in the SQL table

It more looks like ♂ sign but thinner or a vertical tab Char VT sign, but when I copy it to word document or SQL query page it displays like a white space. Only Notepad++ configures it as VT sign. I tried to copy that sign to google search bar but what I saw is only a white space.

I wonder it must come from different language keyboard or something I have no idea what's about.

Anyone recognize it?

---------------update--------------------

I found out this special character doesn't display in here correctly. I added a picture here

QIWEN HU
  • 239
  • 2
  • 8
  • 19
  • Can you replace everything but say regular letters and numbers instead of trying to find that character specifically? – Scath Oct 26 '17 at 18:25
  • 2
    Use `unicode()` to find out the value for that character. Then use that in `replace()`. – SQLChao Oct 26 '17 at 18:41
  • I agree with @SQLChao, you can use an SQL function to find the true value of the character, then you can reliably replace it. – RobertL Oct 27 '17 at 02:15
  • here is ur possible solutions https://stackoverflow.com/questions/46537308/how-to-identify-unicode-text-in-sql/46561056#46561056 – Yogesh Sharma Oct 30 '17 at 10:41

3 Answers3

3

Represent the VT (vertical tab) character as a Transact-SQL string with char(11).

Almost any keyboard will send this character with CtrlK.

RobertL
  • 365
  • 1
  • 9
0

Using python:

<str_value_with_VT>.replace((b'\x0b').decode(),"")
Nick is tired
  • 6,860
  • 20
  • 39
  • 51
xiaoguazh
  • 31
  • 1
0
Replace(columnName, char(11), '')
Xavier Guihot
  • 54,987
  • 21
  • 291
  • 190
Manoj
  • 11
  • 2