freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "James K. Lowden" <jklowden AT freetds.org>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] unicode
- Date: Wed, 23 Jul 2008 14:15:30 -0400
Murray, Laura (US) wrote:
> If I take the N away, the insert works fine, but the characters are
> garbled during transmission, of course. Actually to be more specific,
> some of the Asian characters appear properly on the SQL Server side, but
> others appear as little boxes.
Can you do:
select cast(<colname> as binary)
from JHK_PS_SNOTE AT JJPTRNG.AM
where <key> = 'FTR1'
-- or whatever produces one row
on SQL Server and on Oracle, so we can compare the difference? Also, a
TDSDUMP log of the insert flowing to SQL Server will be illuminating.
I think you may be completely stuck. If
1. your gateway depends on compatible SQL implementations, and
2. Microsoft requires the 'N' prefix, and
3. Oracle prohibits it, then
it's hard to see what anyone can do.
--jkl
-
Re: [freetds] unicode
, (continued)
-
Re: [freetds] unicode,
Jason Young (Morgon), 07/22/2008
- Re: [freetds] unicode, James K. Lowden, 07/22/2008
-
Re: [freetds] unicode,
Christos Zoulas, 07/22/2008
-
Re: [freetds] unicode,
James K. Lowden, 07/22/2008
-
Re: [freetds] unicode,
Christos Zoulas, 07/22/2008
-
Re: [freetds] unicode,
James K. Lowden, 07/22/2008
- Re: [freetds] unicode, ZIGLIO, Frediano, VF-IT, 07/23/2008
- Re: [freetds] unicode, James K. Lowden, 07/23/2008
- Re: [freetds] unicode, Murray, Laura (US), 07/23/2008
- Re: [freetds] unicode, Jason Young (Morgon), 07/23/2008
- Re: [freetds] unicode, James K. Lowden, 07/23/2008
- Re: [freetds] unicode, Murray, Laura (US), 07/24/2008
- Re: [freetds] unicode, James K. Lowden, 07/25/2008
- Re: [freetds] unicode, Murray, Laura (US), 07/29/2008
- Re: [freetds] unicode, James K. Lowden, 07/29/2008
-
Re: [freetds] unicode,
James K. Lowden, 07/22/2008
-
Re: [freetds] unicode,
Christos Zoulas, 07/22/2008
-
Re: [freetds] unicode,
James K. Lowden, 07/22/2008
-
Re: [freetds] unicode,
Jason Young (Morgon), 07/22/2008
Archive powered by MHonArc 2.6.24.