Re: Conversion emoji symbols to UTF-8

With version 0.95.91 all works fine. looks like this issue was fixed
earlier.

Btw, when approximate date of release 1.0?

Regards.

On 18 April 2016 at 10:05, Velichko Yuriy <[email protected]> wrote:

> Ok, I will update freetds and tell you result.
>
> On 18 April 2016 at 00:19, Frediano Ziglio <[email protected]> wrote:
>
>> Looks like an encoding bug. Time ago I fixed a similar issue.
>> Could be you don't have this fix.
>>
>> Frediano
>> On 17 Apr 2016 20:20, "Velichko Yuriy" <[email protected]> wrote:
>>
>> > 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
>> >
>> _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>
>
>
> --
> ​С уважением, Величко Юрий.
>



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