Re: Conversion emoji symbols to UTF-8

Here some examples of query result:

SELECT N'👍'
dbdatlen() == 4
"\x00\xFF\x91\x8D"

SELECT N'тест 👍 test'
dbdatlen() == 18
"\xD1\x82\xD0\xB5\xD1\x81\xD1\x82 \x00\xFF\x91\x8D test"

To store data and show it in UI I use Qt:
QString::fromUtf8();


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

> Can you post a small dump?
>
> You could try a simple query like
>
> SELECT N'hello some emoticons'
>
> Frediano
>
> 2016-04-17 13:19 GMT+01:00 Velichko Yuriy <[email protected]>:
> > 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
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



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