freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Daniel Fazekas <fdsubs AT axelero.hu>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] Problem with current snapshot
- Date: Thu, 13 Nov 2003 17:57:09 +0100
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] 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
Archive powered by MHonArc 2.6.24.