Re: Output from SQL Server database

Could you please reply to my questions?

Oracle connector support was developed by me and some people with an Oracle
server which provided all necessary logs to fix all issues.

There are different reasons why the result from query is that every
character is followed by a NUL characters:
- server inserted ucs2/utf16 on a single characters column;
- server inserted ucs4 on a ucs2 column (this could happen for a mismatch,
unfortunately *nix drivers came in two versions, one with sizeof(SQLWCHAR)
== 2 and one with sizeof(SQLWCHAR) == 4 == sizeof(wchar_t) );
- data in the database are inserted correctly but client did not get
results correctly.

Regards,
  Frediano

Frediano

2014-11-07 17:23 GMT+00:00 Turk, Scott A <[email protected]>:

> Thanks for the suggestion, but after adding that it still has the same
> problem.  Here is what is contained in that section.
>
> [CSI]
>         host = xxx.xxx.xxx.xxx
>         port = 1433
>                client charset = CP1252
>         tds version = 7.2
>
>
> SCOTT TURK
> DATABASE ANALYST, DBA
> COMPUTER SERVICES - MIS
> MISSOURI STATE UNIVERSITY
> [email protected]
> (417) 836-6195
>
>
> -----Original Message-----
> From: FreeTDS [mailto:[email protected]] On Behalf Of
> Mike Grau
> Sent: Friday, November 07, 2014 11:14 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Output from SQL Server database
>
> On 11/07/2014 11:05 AM, Turk, Scott A wrote:
> > Hi, I've enabled the wide support and it didn't solve the issue.  Is
> there a setting to change or add to the odbc.ini or the freetds.conf files?
>
> In your freetds.conf have you tried
>
>   client charset = CP1252
>
> in the sqlserver stanza?
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>