result cannot copy

[baker0611]

• MSSQL Extension Version:
• VSCode Version:
• OS Version:

Steps to Reproduce:

1. select * from tables
2. the result cannot copy

[MattIrv]

Thanks for your report. I'm not able to reproduce this, and am able to copy by selecting results in the query grid and then right-clicking and choosing copy or using the ctrl+c keyboard shortcut.

Could you provide more details about the steps you're taking to get this problem? Additionally, could you please provide your extension version, VS Code version, and OS version so that we can try to track this down? You can get the extension version by going to the extensions pane in VS Code and looking at the number next to the "mssql" extension, and the VS Code version by going to Help > About in the VS Code menu bar (or "Code > About Visual Studio Code" if you're on a Mac). Thanks!

[baker0611]

if there some chinese words, it dose not work.

1. insert table(xxx) values('一二三四五')
   2.select * from table
   3.copy（i cann't copy）

[MattIrv]

Thanks for the update, though I still can't seem to reproduce it.

One note: Depending on your database collation you may have to insert Chinese characters as a unicode string with a leading N, like insert table(xxx) values(N'一二三四五'). If you're seeing it show up as ????? characters, this could be the problem. See https://support.microsoft.com/en-us/help/239530/you-must-precede-all-unicode-strings-with-a-prefix-n-when-you-deal-wit for more info

[baker0611]

display normally, save as json,csv,excel all in good working, but the copy dose not work, i could not paste the reasult

[baker0611]

Is it solved? It should be something wrong of character encoding。 v1.18.1 (1.18.1)

[MattIrv]

Unfortunately we still haven't been able to reproduce it, but will keep looking at it. If there's any additional information about what sort of things you can or cannot copy, please let me know.

What operating system are you running when you get this error?

[MattIrv]

Update: I'm seeing this on Linux (Ubuntu) for all queries, not just ones that return unicode characters, and will look into it. Are you using Linux?

[MattIrv]

On Linux, this is happening because we have an undocumented dependency on the utility xclip, which may not be installed by default.

As a workaround, you can install xclip through your Linux distribution's package manager (for example by running sudo apt install xclip on Ubuntu).

I will continue to look into how we can make copy/paste work on Linux without requiring users to install xclip.

[baker0611]

on mac os 10.13.2 (17C88)