Re: Conversion emoji symbols to UTF-8
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4eF8hiit9-ycG-O7-zTqi+g9UF6wh5gLMrvQab=4hSoNQ@mail.gmail.com> |
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