Re: UTF-8 issue

On Tue, 8 Jan 2019, Deepa Umesh wrote:

> Hi Peter,
> I set ClientCharset=CP1252 in odbc.ini (unixODBC)
> But the result is as previous :

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

Hi Deepa,

Normally this encoding causes everything to be mapped across so above 
would not occur.  Recommend checking FreeTDS logs to confirm this is 
actually encoding used by FreeTDS.

Also make sure FreeTDS uses libiconv when compiling.

regards,
Peter

> So do I need to reinstall freetds with this configuration in freetds.conf ?


> Request you to provide additional info on installation stuff.
> Also is there any config flags to be set?
>
> Thanks,
> Deepa
>
> -----Original Message-----
> From: FreeTDS <[email protected]> On Behalf Of Peter Deacon
> Sent: Tuesday, January 8, 2019 1:50 PM
> To: FreeTDS Development Group <[email protected]>
> Subject: Re: [freetds] 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
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> https://lists.ibiblio.org/mailman/listinfo/freetds
> This message contains information that is confidential and/or may be privileged. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution or copy of this message and/or its attachments is strictly prohibited. If you have received this message in error, please advise the sender immediately by replying to this email and delete this message. We are committed to your privacy. For more information, please see our Privacy Policy at http://www.aptean.com/privacy-statement
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> https://lists.ibiblio.org/mailman/listinfo/freetds
>