Skip to Content.
Sympa Menu

freetds - Re: [freetds] Output from SQL Server database

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Output from SQL Server database
  • Date: Mon, 10 Nov 2014 09:57:36 +0000

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 <SATurk AT missouristate.edu>:

> 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
> SATURK AT MISSOURISTATE.EDU
> (417) 836-6195
>
>
> -----Original Message-----
> From: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] 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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page