2 questions about FUSIO 5.1.0 (UUID`s / ÖÜÄ)

[J. Staub]

Hello,
I am very excited about this project. However, I still have a few questions that I have not yet found an answer to.
I have been using PostgreSQL for my projects for years. It is not a problem to use this RDBMS with Fusio.
1. Is it possible to use UUIDS as a primary key with Fusio (5.1.0)?
Example:
http://<server-ip>:<port>/kunden/ff61232b-3935-e9e6-d970-aab8c2541f32
In Postgres, the ID column is defined as UUID
Some attempts lead to an error message
{
"success": false,
"title": "Internal Server Error",
"message": "The server encountered an internal error and was unable to complete your request."
}
My guess is that Fusio processes this column internally as a "string".
Serial primary keys (1...n) work with Fusio without any problems

2. In the JSON server response, umlauts ä ö ü are not output as such. Is this possibly a configuration error on my part?

Thank you

[Christoph Kappestein]

Hello,

great that Fusio helps you. Regarding your questions:

1. Could you tell me which SQL action do you use in this case. Also can you show me the log/app.log to see the actual error, you could also set the APP_ENV to "dev" to see the actual error.

2. In general this should be only JSON encoding, so if you JSON decode the data on your client it should have the fitting format. If this is an encoding problem you may wan to check the character encoding in your database, it should be UTF-8.

best regards
Christoph