About EasyMorph Tutorials & Examples Web-help

Character set problems

Hi,

I have streetnames but as they are extracted from the database there seems to be an issue of character set. Example below. Also when I query the database itself using sql developer, it seems to be a problem.
Is there a way of fixing that in EasyMorph ? Or can I at least filter the problematic records in the dataset in some way ?

image

In your screenshot there is tab “Suggestions”. Does it contain any suggestions when you click it?

The only suggestion in that windows is that 4 text values have repeating spaces. So no suggestions for the character set problems…
Any other suggestions ?

Hi Nikolaas,

Most likely, that database value actually contains a character which can’t be displayed with common Windows fonts. You can try to copy-paste that character to an expression and filter by it or replace it with some other character.

Thanks. I could filter them that way.

To learn more about EasyMorph visit easymorph.com.