Re: Conversion emoji symbols to UTF-8

On 17 Apr 2016 12:59, "Velichko Yuriy" <[email protected]> wrote:
>
> I use UTF-8 charset according to docs:
>
> http://www.freetds.org/userguide/unicodefreetds.htm
>
> My .conf includes next rows:
>
>     tds version = 7.0
>     client charset = UTF-8
>
> All worked as expected until the emoji symbol appeared in the data string.
>
> In result I got ??? symbols.
>

Data in the database are stored correctly?

> If to try example from answer in this post  (all string is emoji) the
> returned data from method dbdata() will be an empty string with non zero
> lenght (about 60 for example).
>
> Here I have read
> http://www.freetds.org/userguide/localization.htm
> that not all symbols can be converted properly. Looks like this is my
case.
>
> But maybe some one faced with this problem and solved it with FreeTDS?
> Because using emoji is not rare case in our time.
>
> Maybe need to use another encoding, or something else?
>
> Thanks!
>

Are you using iconv correctly? Don't expect to work without it.
Which library are you using?
Does the output work correctly with utf8?

Frediano