Re: Conversion emoji symbols to UTF-8

Yes, without "use utf-16" symbols are broken.
Set
use utf-16 = yes
and
tds version = 7.2
fixes this problem on mac.

If tds version = 7.0 - symbols are broken.

On 19 April 2016 at 13:26, Frediano Ziglio <[email protected]> wrote:

> 2016-04-18 21:46 GMT+01:00 Daniel Fazekas <[email protected]>:
> > 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?
>
> This as replacements iconv use utf16 in place of ucs2.
> This however reminds me that "use utf-16" option default should be
> changed to 1 (true) for 1.0 version!
> I'm doing it right now.
>
> Frediano
>
> > 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
> >
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 
​С уважением, Величко Юрий.
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds