TSQL: I have one basic querying problem qr

Question

Query:

DECLARE @Patd_base nvarchar(50) = '‪axx';

PRINT @Patd_base

Output is

?axx

Why is the ? in the output? What does it mean?

Thanks for the help!

Seems to be similiar to [Linq query not behaving as expected](https://stackoverflow.com/a/36424445/5070879). The letter 'a' is not a Latin 'a' or you have some control characters. Using `DECLARE @Patd_base nvarchar(50) = N'‪axx';` will not cause implicit conversion [db<>fiddle demo](https://dbfiddle.uk/?rdbms=sqlserver_2017&fiddle=2ec577b96ad74fc8a7a9ca4022e26738) — Lukasz Szozda, Nov 14 '20 at 07:48

score 1 · Accepted Answer · answered Nov 14 '20 at 05:19

1

I believe you copied and pasted the value 'axx' from elsewhere. It has a hidden extended character in it.

When I copy/pasted your command above into Notepad++, and converted to ANSI encoding, I got 'â€ªaxx'

answered Nov 14 '20 at 05:19

seanb

1 Answers1