[#SQL-18] wrong encoding of umlaut characters in column header

Confluence SQL Plugin

Created: 13/May/07 02:09 AM Updated: 13/May/07 08:59 AM

Component/s:

SQL macro

Affects Version/s:

3.2.1

Fix Version/s:

None

Time Tracking:

Not Specified

Environment:

Confluence 2.5.1 standalone, Java 6

Labels:

Description

« Hide

Umlaut characters are not properly encoded. This query:

{sql:dataSource=pck|output=wiki}
select
PersKtoStrasse as "Straße"
from
sPersKto
{sql}

will display a column header "StraÃŸe" instead of "Straße".

Umlaut characters in database content is properly displayed though.

All

Comments

Work Log

Change History

FishEye

Crucible

Related Builds

Sort Order:

[ Permlink | « Hide ]

If the header is coming from the database directly as a column name then:

Is the fly-over label for the column correct? In other words, if you mouse over the header column, does the fly-over text appear correctly? If so, then use columnLabel=true to have that label appear as the column heading.

In your example above where the label is defined in the sql statement:

Worked correctly in my installation and database (postgresql)
I suspect an environment problem - the sql macro doesn't do anything specific to character encoding and certainly nothing different between the headers and the column data.