[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] Charset issues...
From:       Michael Higgins <listinfo () banfieldgroup ! com>
Date:       2007-07-31 18:46:15
Message-ID: 20070731114615.7b3f85e8.listinfo () banfieldgroup ! com
[Download RAW message or body]

On Tue, 31 Jul 2007 12:08:16 -0400
"Reid, Roger L." <roger.reid@dpw.com> wrote:

> Amazing!  
> 
> I am sweating bullets over a conversion issue and almost deleted this incoming \
> FreeTDS mail without reading it - and  JKL gave me the EXACT answer I needed - and \
> I'm not the one who asked.   It hadn't occurred to me yet that it might be an issue \
> in the char mapping within FreeTDS. It was, and it took me about 30 seconds to \
> solve it. 
> I don't know if this helps Michael Higgins, who asked - but it just saved me a lot \
> of barking up the wrong tree.

;-)

Well, here I am, still having the same problem. 

My localization, in 'tsql': 
locale is "en_US.utf8"
locale charset is "UTF-8"

I kept having the same issue as before. I finally decided the problem was the \
so-called 'smart quotes' that shouldn't be there anyway, so I cleaned up the database \
and my script works again.

I've kept looking for information, trying to find that magic bullet, and keep finding \
assertions that unix odbc isn't utf-8 capable. (I'd love to put that concern to bed.)

Just in case anyone has another suggestion, what I'm doing is grabbing a name from \
sql server 2000 table and looking it up in a mysql table to get the related mysql \
table id. I'm using perl/dbi/odbc. 

What I had done (before moving development to a better platform) is to update the \
mysql table from windows. So I found, viewing the mysql data on windows, character \
mangling was somehow in my table already... so, even if the '?' had come up like '´' \
it would likely have failed.

Hopefully, this problem won't just keep cropping up every time someone enters a new \
name with an apostrophe.

> 
> Guess I should go play the lottery now!

Good luck!

-- 
Michael Higgins <listinfo@banfieldgroup.com>
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


[prev in list] [next in list] [prev in thread] [next in thread]