Iconv(Col,"MC/N")

[roy]

Hi All,
I'm experiancing an unexpected behaviour from the Iconv function when using te MC/N conversion code.

The expected behaviur on my part is that it should work as documented,
in my case preserving the space characters from the original string.
For some strange reason the convrted string shows i the DB missing the spaces between the words/
The following example is taken from the designer's help screens:

Code: Select all

X = Oconv("John Smith 1-234", "MC/N")
 X = "John Smith -"
 

Any thoughts?

P.S.
DS version is 7.5
OS is Windows
DB is Teradata

[roy]

Roflmao
Was quick on the gun on my part
seems the programer ment to perform MC/N but instead used the MCA conversion sode

[ray.wurlod]

The problem, in short, was between the keyboard and the chair.