XML into a text field (form)

[Guest]

I am trying to take an XMLData argument from an ActiveX control and store
this XML in a field in Access. The XMLDATA is maybe 2000 characters long.

I would prefer to do this in ADP, not MDB.

I am trying to use a VARCHAR(7500) field.

I have it written correctly, but it is failing to put the whole string in
the text field (it is only showing like the last 30 chars).

I've been trying to troubleshoot this all morning, I could really use some
help

-aaron

 

[Sylvain Lafontaine]

Possible that the XMLData is not encoded in Ascii but in UTF-8. Try using a
varbinary or an image field instead.

If it is encoded in Unicode (UTF-16), use nvarchar or ntext.

S. L.

 

[Guest]

thank you i will give that a shot.

i have been writing the XML files to the filesystem in the meantime-- i
really hope I can get that working in the morning

-aaron