How to escape German Umlaut in path to truststore

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
StephanH2
Posts: 7
Joined: Mon Dec 30, 2013 4:41 pm

How to escape German Umlaut in path to truststore

Post by StephanH2 »

Dear all,

I have successfully connected base to MySQL but have now a problem with a colleague who has a German Umlaut (Ä) in her path to the truststore file which is needed to connect to the server. I use the Java startup parameters

-Djavax.net.ssl.trustStorePassword=mypassword
-Djavax.net.ssl.trustStore=D:\Aenne\truststore

which works fine. But in her case, the parameters are

-Djavax.net.ssl.trustStorePassword=mypassword
-Djavax.net.ssl.trustStore=D:\Änne\truststore

and that does not work. Can anyone tell me how to escape the German Umlaut ('Ä) in this case?

Thank you and best regards
Stephan
OpenOffice 4.0 on Win7
User avatar
Villeroy
Volunteer
Posts: 31344
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to escape German Umlaut in path to truststore

Post by Villeroy »

Avoid any umlauts in the name. Only use latin letters, digits and underscores, no spaces, no quotes, no braces.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
StephanH2
Posts: 7
Joined: Mon Dec 30, 2013 4:41 pm

Re: How to escape German Umlaut in path to truststore

Post by StephanH2 »

Thank you for your quick reply. I am using spaces without problems. Is there now way to use umlauts?

I can use umlauts without problems when I pass the path to the truststore through the URL itself using the MySQL Connector/J option "trustCertificateKeyStoreUrl" (see http://dev.mysql.com/doc/connector-j/en ... rties.html).

Do you have an idea what changes to make to use it directly in the start up parameters?
User avatar
Villeroy
Volunteer
Posts: 31344
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to escape German Umlaut in path to truststore

Post by Villeroy »

Well, if we are discussing an URL:
ä => %E4
ö => %F6
ü => %FC
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply