Unicode characters when selecting Note column

[Uffe]

Hi all,


I've got a problem with a doc template which uses a custom SQL query to output data from t_object.Note.

Non-English characters in this column are not output as characters in the document, but as character codes (eg É instead of É).
Selecting from the t_object.Name column does not cause this problem. In the schema, t_object.Name is an nvarchar(255) and t_object.Note is an nvarchar(max).

I get the exact same result if I run the query through EA's SQL scratch pad: it works with Name, but not with Note.

There is no formatting in the Note, just regular text.

I'm in a SQL Server repository, using client 15.0.1512 and in the XML Specifications section of my client preferences, the Code Page is set to windows-1252.

What's going on?

More to the point, how do I get it to work?


/Uffe

[Geert Bellekens]

You have to tell EA it's formatted text.

In your (SQL Server) query do

Select o.Note as [Description-Formatted] from t_object o

In the template use {Description.Formatted}

Geert

[Uffe]

You have to tell EA it's formatted text.

It isn't formatted. It's regular, non-formatted text.

[Uffe]

... but the Formatted hack works.

Thanks Geert, and I guess we can add plain text to the list of things EA doesn't do very well...

/U

[Geert Bellekens]

Since version 15 they started to xml-escape special characters in the notes fields.

So if you now use a notes field from SQL in documents (or searches, or...) you have to treat it as it would contain formatted text.

Geert