encrypt in PHP on server, decrypt in Xojo on client

General
1

Dear all,

I have Arabic and Chinese text in a DB on a server. Via PHP page my XOJO application can read them.
I would like to encrypt them in the PHP page and decrypt it in XOJO.
Does anyone know what would the easiest way to do this?

Thanks

2

I do it all the time. MySQL server running in UTF-8 setting and then encrypting it before transfer (using JSON) to Xojo. Just make sure you are super-careful about setting the encoding Xojo-side.

3

Mattias, what PHP encryption method do you use?
thanks

4

In one project I use the Twofish encryption via MBS plugin for legacy reasons. The other is using standard AES_256.

5

Seems like a good place to point out my free M_Crypto module that implements AES and Blowfish, and comes with Bcrypt and Scrypt too, all in native Xojo code.

https://github.com/ktekinay/M_Crypto

6

And check the CipherMBS class. It can be configured with various algorithms, patterns and block types.

e.g. in PHP you can do similar with the cipher methods here:
http://php.net/manual/en/function.openssl-encrypt.php

so it should be compatible.