Getting wrong output when try to run SQL Server query

Question

I am trying below query but not getting proper output. It will return me garbage value.

I have try this query :

select convert(nvarchar(max), '.4ah開発進捗状況（週報）')

Output of my query :

.4ah??????(??)

Thanks

Paresh J · Accepted Answer · 2017-05-12 06:36:50Z

4

Try adding 'N' before your chinese string, it simply converts your string to unicode. Just check this:

select convert(nvarchar(max), N'.4ah開発進捗状況（週報）')

Using 'N' prefix means declaring the string as nvarchar data type, rather than varchar.

answered May 12, 2017 at 6:36

Paresh J

2,4293 gold badges26 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1