Re: Conversion emoji symbols to UTF-8

It is actually odd that merely upgrading solved that emoji issue.
Emojis being largely in the Supplementary Multilingual Plane of Unicode require true UTF-16 support rather than the legacy UCS-2 encoding on the server communication side.

In FreeTDS terms, that means that in addition to version 0.95+ you ought to include the following extra setting in your configuration file:
use utf-16 = yes

So a complete sample configuration would look something like
tds version = 7.2
client charset = UTF-8
use utf-16 = yes

Was it a Windows platform peculiarity that UTF-16 worked even with that required setting missing?
In any case, I'd add that to your configuration just to be sure.
It certaintly was necessary for me on Mac and Linux.

> On Apr 18, 2016, at 12:09, Velichko Yuriy <[email protected]> wrote:
> 
> With version 0.95.91 all works fine. looks like this issue was fixed
> earlier.
> 
>>>>>>>> On 17 Apr 2016 12:59, "Velichko Yuriy" <[email protected]> wrote:
>>>>>>>> My .conf includes next rows:
>>>>>>>>    tds version = 7.0
>>>>>>>>    client charset = UTF-8