There are at least four types of characters which are treated differently when XOGing

- standard ascii (excluding the next two types) require nothing special and you can use even ANSI code xml input files
- characters used in html escape codes and XML tags eg & and " should be avoided in data fields but can be used with the proper escape sequences
- chracters that have special usage in Clarity eg / which works most of the time also when XOGing except in OBS's where / is used to indicate the next level
- extended ascii characters which are not of the two types above, if the input file is UTF-8 encodes they will XOG in just fine and they will XOG out without any special measures. If you use the GUI client there is no encoding to worry about.
Not that you can also save an xml file containen extend ascii characters with UTF-8 encoding so that it can be used as XOG input.

The euro character is just one extend ascii and need UTF-8 encoding in writing. for writing no special measured are needed.

First you need an editor which can display and save those other than non-ascii characters.
Create the input file. This example is with minimum data for project with just the name and ID with non-ascii chracters.
Save the input file with UTF-8 encoding and just XOG in normally with the command line client.

Attachments

There are at least four types of characters which are treated differently when XOGing

- standard ascii (excluding the next two types) require nothing special and you can use even ANSI code xml input files
- characters used in html escape codes and XML tags eg & and " should be avoided in data fields but can be used with the proper escape sequences
- chracters that have special usage in Clarity eg / which works most of the time also when XOGing except in OBS's where / is used to indicate the next level
- extended ascii characters which are not of the two types above, if the input file is UTF-8 encodes they will XOG in just fine and they will XOG out without any special measures. If you use the GUI client there is no encoding to worry about.
Not that you can also save an xml file containen extend ascii characters with UTF-8 encoding so that it can be used as XOG input.

The euro character is just one extend ascii and need UTF-8 encoding in writing. for writing no special measured are needed.

If I drop the filter I get all the projects including that project.
My system is with MS SQL Server and if you have followed the discussion on LinkedIn other have the same problem while it works in Oracle.

If I use
select id, name, code from inv_investments where code ='今日は'
in a lookup and go to preview no results.

I do have access to the sandboxes which are Oracle. However, apparently they have not been rebooted since April and the XOG GUI client is not working and being https I don't know how to use the regular client without the certificate.

If I test the SQL query results in a lookup on the sandbox the query returns that one record.

The MS SQL result is apparently because if I run the query in SQL Management Studio I get the results in the attachments.
I am positive that the collation in my MS SQL is as specified in the documentation.
So it appears to be a MS SQL Server feature which does not exist in the Sandbox Oracle databases.

If I drop the filter I get all the projects including that project.
My system is with MS SQL Server and if you have followed the discussion on LinkedIn other have the same problem while it works in Oracle.

If I use
select id, name, code from inv_investments where code ='今日は'
in a lookup and go to preview no results.

I do have access to the sandboxes which are Oracle. However, apparently they have not been rebooted since April and the XOG GUI client is not working and being https I don't know how to use the regular client without the certificate.

If I test the SQL query results in a lookup on the sandbox the query returns that one record.

The MS SQL result is apparently because if I run the query in SQL Management Studio I get the results in the attachments.
I am positive that the collation in my MS SQL is as specified in the documentation.
So it appears to be a MS SQL Server feature which does not exist in the Sandbox Oracle databases.

Martti K.

.

Martti K.

Hi Martin,

Seems same behaviour in development environment also. Not sure what are different settings in Sandboxes. But one thing I noticed is in our Sql Server management studio when I try to get the result with query that you use
I am getting different window.
I have used two query to get result. Please see the attached image for query and result.
You have any Idea on why the different behaviour.

If I drop the filter I get all the projects including that project.
My system is with MS SQL Server and if you have followed the discussion on LinkedIn other have the same problem while it works in Oracle.

If I use
select id, name, code from inv_investments where code ='今日は'
in a lookup and go to preview no results.

I do have access to the sandboxes which are Oracle. However, apparently they have not been rebooted since April and the XOG GUI client is not working and being https I don't know how to use the regular client without the certificate.

If I test the SQL query results in a lookup on the sandbox the query returns that one record.

The MS SQL result is apparently because if I run the query in SQL Management Studio I get the results in the attachments.
I am positive that the collation in my MS SQL is as specified in the documentation.
So it appears to be a MS SQL Server feature which does not exist in the Sandbox Oracle databases.

Martti K.

.

Martti K.

Hi Martin,

Seems same behaviour in development environment also. Not sure what are different settings in Sandboxes. But one thing I noticed is in our Sql Server management studio when I try to get the result with query that you use
I am getting different window.
I have used two query to get result. Please see the attached image for query and result.
You have any Idea on why the different behaviour.

Attachments

If I have that where condition in the query I do not get any results.
If I don't have I get the data, but the character are not properly displayed.

I don't know the reason. A db expert could find out.
Apparently the characters are properly displayed in my GUI, but the way they are presented to the database and stored in the database is not doing the job properly. I don't know why mine is not and yours is.
My db dis 32 bit.

Maybe the reason is in the difference of the database and the setup. See below for mine.