[freetds] Charset issues...
Michael Higgins
listinfo at banfieldgroup.com
Tue Jul 31 14:46:15 EDT 2007
On Tue, 31 Jul 2007 12:08:16 -0400
"Reid, Roger L." <roger.reid at 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 at banfieldgroup.com>
More information about the FreeTDS
mailing list