Repository.SQLQuery() treats empty string values as bin.base64

[Uffe]

Hey everybody,


Repository.SQLQuery() goes crazy and starts hallucinating binary data when face with an empty string in the query results.

Instead of returning just an empty or self-closing XML tag, you get
    <ColumnName xmlns:dt="urn:schemas-microsoft-com:datatypes" dt:dt="bin.base64"></ColumnName>

This is on 15.0.1512 on Windows 10/64 and an eapx repository.
Can someone check if it's still broken in 15.1 or 15.2?

Try

Code: (VBScript) [Select]

Session.Output Repository.SQLQuery("Select null as NullVal")
Session.Output Repository.SQLQuery("Select ' ' as SpaceString")
Session.Output Repository.SQLQuery("Select '' as EmptyString")

Null gives a self-closing tag.
A string with a whitespace gives an XML tag with a whitespace.
An empty string gives the result above.


/Uffe

[qwerty]

Can't do that on EAP. Sorry.

q.