char to varchar

[ds_is_fun]

We had issues in moving data from char to varchar fields. I have trimmed all char before writing to varchar. Is there anything else I should be looking at? thx

[michaeld]

yah, char will pad all unused bytes with CHAR(0). Trim does not remove them. I use the convert function:

convert(char(0),'',inputcolumn)

[ray.wurlod]

The three-argument version of Trim() will remove them.

Performance Tip
Initialize a stage variable to Char(0) and do not derive it. That way the Char() function is evaluated only once per run, rather than once per row.

Code: Select all

Trim(InLink.TheString, svNUL, "A")

[synsog]

Simple and perfect solution. Very helpful :D

[ray.wurlod]

Thank you. It was simple (and presumably helpful) three years ago too.