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: Velichko Yuriy <velichko.yuriy AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Conversion emoji symbols to UTF-8
  • Date: Sun, 17 Apr 2016 15:19:29 +0300

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 <freddy77 AT gmail.com> wrote:

> On 17 Apr 2016 12:59, "Velichko Yuriy" <velichko.yuriy AT gmail.com> 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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



--
​С уважением, Величко Юрий.




Archive powered by MHonArc 2.6.24.

Top of Page