Re: UTF-8 issue

On Tue, 8 Jan 2019, Deepa Umesh wrote:

> Hi ,
> I am trying to rephrase my question with more clarity,

> We are using UTF-8 as encoding in our product, which uses single byte of 
> character data, But when we attempt to use non US ASCII UTF-8 charecters 
> , we are having encoding problems similar to the following,

> Insert query : insert into altitem values ('あなたの犬を散歩したいと思います');

> [FreeTDS][SQL Server]Some character(s) could not be converted into 
> client's character set.  Unconverted bytes were changed to question 
> marks ('?')

>> [sqlprog1]
>> Driver=/usr/local/freetds-1.00.97/lib/libtdsodbc.so
>> Server=172.16.127.134
>> Database=sqlprog1_catdev19
>> Port=1433
>> TDS_Version=7.3
>> Client Charset = UTF-8.

Hi Deepa,

Set ClientCharset=CP1252

regards,
Peter