Skip to Content.
Sympa Menu

freetds - Re: [freetds] Freebcp character conversion Issue

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: <vasanth.sengunthar AT accenture.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Freebcp character conversion Issue
  • Date: Thu, 23 Mar 2017 06:42:00 +0000

Hi,

Thanks for the suggestions Fredino, I created format file with SYBBINARY
datatype for single issue column and it seems to work with freebcp command.

Regards,
Vasanth

-----Original Message-----
From: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
Frediano Ziglio
Sent: Wednesday, March 22, 2017 5:56 PM
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Freebcp character conversion Issue

Then the column contains garbage... cipher text means binary and binary
should not be stored in a sysname column which, as Microsoft documented it,
is like a nvarchar(128).

The "workaround" would be to avoid any conversion and save as raw (so native
format without conversions) which currently is not implemented.
Or convert the column to a binary format (I would say varbinary(256)).

Frediano


2017-03-22 11:40 GMT+00:00 <vasanth.sengunthar AT accenture.com>:
> 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:freetds-bounces AT lists.ibiblio.org] On Behalf Of
> Frediano Ziglio
> Sent: Wednesday, March 22, 2017 4:23 PM
> To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> 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 <vasanth.sengunthar AT accenture.com>:
>> 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
> FreeTDS AT lists.ibiblio.org
> https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.ibiblio.org_
> mailman_listinfo_freetds&d=DwICAg&c=eIGjsITfXP_y-DLLX0uEHXJvU8nOHrUK8I
> rwNKOtkVU&r=vQqnb-FGv_1Cq8lIuKD95mRfUO0gBovRe0eqdms7a5s&m=9ohuXqX4RTRw
> oKFRR4Wnuo74pTeQQT046YqdTwZ71pc&s=WF2lSWQvV-WIiZX1t-TYi-SpxTAE2sjqgcx5
> No7MBb4&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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.ibiblio.org_
> mailman_listinfo_freetds&d=DwICAg&c=eIGjsITfXP_y-DLLX0uEHXJvU8nOHrUK8I
> rwNKOtkVU&r=vQqnb-FGv_1Cq8lIuKD95mRfUO0gBovRe0eqdms7a5s&m=cQ0czvjOoYiR
> y2uDriiW3AHyVK7qye-hubApPYjVgXg&s=F5PTctaQhsDTLn2SuCnqQi1LAEuaQlaMoBxr
> mcfxhkE&e=
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
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=cQ0czvjOoYiRy2uDriiW3AHyVK7qye-hubApPYjVgXg&s=F5PTctaQhsDTLn2SuCnqQi1LAEuaQlaMoBxrmcfxhkE&e=





Archive powered by MHonArc 2.6.24.

Top of Page