My string length is too long

[efandango]

I am trying to output a query which in turn will feed a data file (xml) to an
exernal app; but the overall field length on some records exceeds 255
characters in some records, and replaces the onerous chracters with a square
character.

I really must keep each field line intact so that the xml parser will read
it, and... to enable me to avoid going cross-eyed at the thought of wading
through tons of metatags on multiple lines.

what are my options, if any?

 

[Lord Kelvan]

well you can set the field in access to memo rather than text is this
what you are looking for

Regards
Kelvan

 

[Brian]

If the issue is just getting a query to include all the characters, one way
to prevent a query from truncating at 255 characters is to SELECT FIRST on
that field instead of just SELECT

This: SELECT First(MyMemoField) FROM MyTable

Instead of this: SELECT MyMemoField FROM MyTable

I cannot remember why, but I'm sure one of the MVP's has the reason (and
probably a better answer to your question, as well).