Forum Discussion

M_McDonald's avatar
M_McDonald
Super Contributor
16 years ago

JDBC Request stripping leading and trailing whitespace from response content

I have a field in a database containing leading and trailing whitespace like this (ignore quotes):

[tt:3i8k4h4l]' Here are some comments  '[/tt:3i8k4h4l]

But it seems that the JDBC Request is stripping the whitespace when creating the response XML like this:

[tt:3i8k4h4l]Here are some comments[/tt:3i8k4h4l]

I need to be able to see the data as-is; can I control this via some option?

6 Replies

  • M_McDonald's avatar
    M_McDonald
    Super Contributor
    16 years ago
    I could get around this by prepending/appending a special character to each field, then stripping it out of the response... but it looks like it is read-only?

    Even if each value was wrapped as CDATA it would work for me (in fact that might be preferable for many situations.)
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    16 years ago
    Hi!

    Please have a go at the upcoming nightly-build and let us know if that works better in this regard (ie preserves spaces..)

    regards!

    /Ole
    eviware.com
  • M_McDonald's avatar
    M_McDonald
    Super Contributor
    16 years ago
    Leading and trailing spaces are now showing up.

    Thanks very much!