Skip to Content.
Sympa Menu

freetds - Re: [freetds] Conversion emoji symbols to UTF-8

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Daniel Fazekas <fdsubs AT t-online.hu>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Conversion emoji symbols to UTF-8
  • Date: Mon, 18 Apr 2016 22:46:36 +0200

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 <velichko.yuriy AT gmail.com> wrote:
>
> With version 0.95.91 all works fine. looks like this issue was fixed
> earlier.
>
>>>>>>>> On 17 Apr 2016 12:59, "Velichko Yuriy" <velichko.yuriy AT gmail.com>
>>>>>>>> wrote:
>>>>>>>> My .conf includes next rows:
>>>>>>>> tds version = 7.0
>>>>>>>> client charset = UTF-8





Archive powered by MHonArc 2.6.24.

Top of Page