Re: mySQL 8 destroyes umlaute

2021-07-09 Thread Bob Sneidar via use-livecode
I did something similar. I created a client-server library. The client encrypts using a unique method that only I know, and the server decrypts using the same method. This way you can have secure traffic without HAVING to go through a web server and all the hoopla that involves (for the uninitia

Re: mySQL 8 destroyes umlaute

2021-07-09 Thread ELS Prothero via use-livecode
Folks, I have posted a sample php file that I have used for a couple of years, that uses aes-256 encryption for database operations. Data is encrypted in Livecode and decrypted by the php script, which posts it to the mysql db. Perhaps it will be of interest and I welcome any feedback. https://

Re: mySQL 8 destroyes umlaute

2021-07-08 Thread Rick Harrison via use-livecode
Hi Tiemo, Could you use a substitution table as a work around patch? Rick > On Jul 8, 2021, at 8:45 AM, Tiemo via use-livecode > wrote: > > Thank you Matthias, > > because it is an existing db and years old LC programs in different versions > out at the customers, I can't modify my old LC p