freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Simon Talbot" <simont AT nse.co.uk>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: RE: [freetds] Problem with current snapshot
- Date: Thu, 13 Nov 2003 17:08:48 -0000
Hmmm,
There could be a clue in here, by changing the client character set as
you suggested to:
client charset = WINDOWS-1252
The WARNING messages were indeed removed -- BUT the main problem of:
DB-Library error:
iconv E2BIG: Error converting between character sets. Output
buffer exhausted.
Operating-system error:
OpenClient
agrep: dblib.c:416: buffer_transfer_bound_data: Assertion `idx >= 0'
failed.
Aborted
WAS ALSO CURED
So it sounds like the WARNING Messages I was receiving were consuming a
buffer of some description which wasn't being properly cleared out and
after enough of the messages was filling up and causing the main message
and fault.
Simon
-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Daniel Fazekas
Sent: 13 November 2003 16:57
To: FreeTDS Development Group
Subject: Re: [freetds] Problem with current snapshot
On Nov 13, 2003, at 16:54, Simon Talbot wrote:
> I also receive some WARNING character data could not be translated to
> the target character set, data will be replaced by ??? Which is also
> odd as everything is english.
It's not quite as odd if the database was written to from a Windows
application.
Note that Microsoft added some extra characters to their single-byte
Windows text encodings, such as the "em dash" character or left and
right quotation marks. Microsoft Office applications also by default
AutoCorrect simple apostrophes to that special pair of quotation marks
and so on...
Many of these don't exist in the iso-8859-1 (Western - ISO) character
encoding.
So if in freetds.conf if you had a line saying "client charset =
ISO8859-1", change it to "client charset = WINDOWS-1252".
This in effect makes iconv use the Windows encoding instead of the ISO,
which is what your source data most likely was in anyway.
The Central European single-byte encodings are called "ISO8859-2" and
"WINDOWS-1250".
--
Daniel
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
-
[freetds] Problem with current snapshot,
Simon Talbot, 11/13/2003
- Re: [freetds] Problem with current snapshot, Daniel Fazekas, 11/13/2003
- <Possible follow-up(s)>
- RE: [freetds] Problem with current snapshot, ZIGLIO Frediano, 11/13/2003
- RE: [freetds] Problem with current snapshot, Simon Talbot, 11/13/2003
- RE: [freetds] Problem with current snapshot, ZIGLIO Frediano, 11/13/2003
- RE: [freetds] Problem with current snapshot, Lowden, James K, 11/13/2003
- RE: [freetds] Problem with current snapshot, Simon Talbot, 11/13/2003
- RE: [freetds] Problem with current snapshot, Simon Talbot, 11/13/2003
- RE: [freetds] Problem with current snapshot, Lowden, James K, 11/13/2003
-
RE: [freetds] Problem with current snapshot,
Simon Talbot, 11/13/2003
- Re: [freetds] Problem with current snapshot, James K. Lowden, 11/13/2003
- RE: [freetds] Problem with current snapshot, ZIGLIO Frediano, 11/14/2003
- RE: [freetds] Problem with current snapshot, ZIGLIO Frediano, 11/14/2003
- RE: [freetds] Problem with current snapshot, Simon Talbot, 11/14/2003
Archive powered by MHonArc 2.6.24.