Re: Conversion emoji symbols to UTF-8
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4f9zWr2SY=AsdYhtayJijbZEEFqFotmU0TBmRK7vv8ovw@mail.gmail.com> |
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