FreeTDS Development Group

[Frediano Ziglio <freddy77 AT 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 <velichko.yuriy AT gmail.com>:
> 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
>>
>
>
>
> --
> С уважением, Величко Юрий.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds