Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem with current snapshot

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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





Archive powered by MHonArc 2.6.24.

Top of Page