Re: Conversion emoji symbols to UTF-8

1 Data stored correctly because, for example SMSS shows emoji as expected
2 I use static db-lib
3 Other unicode text is shown correctly

On 17 April 2016 at 15:05, Frediano Ziglio <[email protected]> wrote:

> 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
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



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