Re: Freebcp character conversion Issue

Hi,

Thanks for immediate response Ferdino, however the table we are trying to backup is of login table with password column((sysname datatype), which is giving conversion issue due to cipher text.

Please suggest if there is any alternate way to backup as we already applied utf-8 and failed with the fix.

Regards,
Vasanth

-----Original Message-----
From: FreeTDS [mailto:[email protected]] On Behalf Of Frediano Ziglio
Sent: Wednesday, March 22, 2017 4:23 PM
To: FreeTDS Development Group <[email protected]>
Subject: Re: [freetds] Freebcp character conversion Issue

Usually this is an indication of:
- you are not uring libiconv;
- the client charset is not able to handle some server character (try utf-8);
- your database contains some garbage.

Are you able to understand which data has the issue?

Frediano


2017-03-22 6:11 GMT+00:00  <[email protected]>:
> Hi,
>
> Recently, I have been working with freebcp command of freetds driver, where I came across character conversion issue while trying to back up the table of MS SQL Server database.
> Please look into the below error and help to get rid of the same as soon as possible.
>
> We did try to declare client charset value with freetds.conf file but that is not useful either.
>
> Error:
> Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?')".
>
>
> Looking forward to your earliest response,
>
> Regards,
> Vasanth
>
_______________________________________________
FreeTDS mailing list
[email protected]
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.ibiblio.org_mailman_listinfo_freetds&d=DwICAg&c=eIGjsITfXP_y-DLLX0uEHXJvU8nOHrUK8IrwNKOtkVU&r=vQqnb-FGv_1Cq8lIuKD95mRfUO0gBovRe0eqdms7a5s&m=9ohuXqX4RTRwoKFRR4Wnuo74pTeQQT046YqdTwZ71pc&s=WF2lSWQvV-WIiZX1t-TYi-SpxTAE2sjqgcx5No7MBb4&e=

________________________________

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
______________________________________________________________________________________

www.accenture.com