The size of VARCHAR is 'unlimited', that's why XML data is exported as CDATA, which is allowed in XML.
If you import this kind of data it should work correctly, but in that case you are dependent of the receiving software. If you like to avoid this situation you better make use of a TEXT column. The limit in that case is 1500 characters. In this situation the text field is exported in a normal (readable) way Tony From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: zondag 15 april 2012 21:42 To: RBASE-L Mailing List Subject: [RBASE-L] - GATEWAY EXPORT XML and VARCHAR data Who has some experience with GATEWAY EXPORT XML? If I use this to send data to another place, through R:BASE's Gateway Export command, data in a LONG VARCHAR field is being encoded. Before the export, in R:BASE, I can SELECT columnname FROM tablename and see the LONG VARCHAR data just as it was entered: DAWN ORLOFF-NIESEN If I do: GATEWAY EXPORT XML myfilename.xml SELECT columnname FROM tablename here is what I see in the file at that location: [CDATA[REFXTiBPUkxPRkYtTklFU0VO]] With xPath, I can pull out the value, but the value I am getting is 'REFXTiBPUkxPRkYtTklFU0VO', not the name that appears in R:BASE. What do I need to do -- at either end -- to get the same value out that R:BASE has in the column in the table? Thanks. Bill
