Re: Character conversion table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Christian Dam (badeanden_at__no_spam_hotmail.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 15:44:55 +0200

Yep, I know the MSdatatype_mappings but unfortunately that's not the one I
was looking for. Your reply, however, have finally convinced me that table I
was told existed, actually do not exist.

For a customer we have set up a replication from SQL Server 2000 to DB2.
Originally the DB2 was located on Windows and everything worked fine. The
customer then moved DB2 to AIX resulting in the line feed characters got
transferred incorrectly, I'm guessing because of the differences between NT
and AIX (the LFCR vs. CR thingy).

Unfortunately I don't have much additional information. It could look like a
ODBC configuration problem, but we don't even know if it is a line feed
characters are transferred incorrectly if it appears within normal row data.
We are using the IBM DB2 ODBC driver version 7.01.00.88.

Thanks
/Christian

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:%23$LROydiEHA.2764@TK2MSFTNGP11.phx.gbl...
> its in the msdb database and its called MSdatatype_mappings. However, this
> doesn't really do what you are looking for. Its pure datatype mappings, ie
a
> datatype in SQL Server to a datatype in access.
>
> Query this table to get an idea of what it actually does.
>
> I think what you want to do is to use a DTS transform to carry this form
of
> conversion out.
>
> What type of a database are you replicating to?
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
>
> "Christian Dam" <badeanden@_no_spam_hotmail.com> wrote in message
> news:ex8Mr%23aiEHA.2848@TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > I have been told a conversion table exist in either the master or the
msdb
> > database which can do a character conversion of data before it is sent
to
> a
> > subscriber. I am not not talking about character set conversion but
about
> > the ability to modify named characters into another named character,
e.g.
> > chr(10)+chr(13) into chr(13).
> >
> > Does anybody know of such a table? I haven not been able to locate it.
> >
> > Cheers
> > /Christian
> >
> >
>
>

Relevant Pages

  • Re: Base36
    ... Thanks Justin. ... > characters that may be confused for other characters when read by a human. ... > "Roy Fine" wrote in message ... >> conversion is each direction is based on the tokens and powers arrays. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ADP report truncates field at 4000 characters
    ... > Since you've said that the text datatype works, if you want to keep your ... Report works fine except it truncates the data in this ... >>> displays only the first 4000 characters. ... >>> app populated via an ADO recordset built via stored proc displays all ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Forth 200x, S\q
    ... Is it true that for \xAB the two hex characters A and B should ... according to 3.2.1.2 Digit conversion. ... Digit conversion). ...
    (comp.lang.forth)
  • Re: Character conversion table
    ... I know some people who are replicating to DB2 on AIX and are using IBM's ... Looking for a book on SQL Server replication? ... > customer then moved DB2 to AIX resulting in the line feed characters got ...
    (microsoft.public.sqlserver.replication)
  • Re: Oracle 11 Server and Unicode UTF-8
    ... every field with too much characters (more than 4000 bytes UTF8 code) can ... columns if you have already database with data in it and then add conversion ... That should allow 3 UTF-8 characters to be stored in the ... I haven't found a good reference for how to best accomplish the conversion ...
    (comp.databases.oracle.server)