LiveCode Forums

Without textEncode
Cˆrls Bˆrbal GonŠlves ‡Ž’—œ – „‚

With textEncode
Càrlès Bàrbal Gonçälves áéíóú çñ ÑÇ

Original text in LiveCode
Càrlès Bàrbal Gonçälves áéíóú çñ ÑÇ

It does not work for me, it's time to return to the origins.

Thanks for everything

Carles

The data I enter directly with PhpMyAdmin, I leave from the base that the client can already have his data and open that show it. I will test the other way, this afternoon or tomorrow

Configuring the database on the server: Safari001.jpg Original text: Càrlès Bàrbal Gonçälves áéíóú çñ ÑÇ Without textEncode: LiveCode001.jpg With textEncode, disappear accented vowels and diacritics: LiveCode002.jpg Servidor: Localhost via UNIX socket: Tipo de servidor: MariaDB Conexión del servidor...

Hi,

I'm sorry I have not explained myself well. I mean, how do you have your database set up? Something like that

Character: latin1_spanish_ci collate: utf8_spanish_ci

Hi ghettocottage,

I have a previous post with my experiment with MariaDB viewtopic.php?f=12&t=31516

Hi ghettocottage There would be some way to know the type of character and collation of the server, I suppose that with PhpMyAdmin you can see how this database is defined? I have XAMPP, locally, with MariaDB and I have not managed to find the right combination. Will not Livecode Community Edition S...

Here you have the relationship. You can see all the possible combinations from 7 to 10.

Barça
Mañana
Càrles
Pingüino
Ramón
Sofía
àèìòù
áéíóú
ÀÈÌÒÙ
ÁÉÍÓÚ
çñ
ÇÑ

Thanks for your answer

Hi, I would like to know if there is someone who uses a database in which accented words or diacritics are stored. They look good in LiveCode and you can search for these types of words and find them. I've been spending about three weeks on it, not wanting to lose time from now, if it's not possible...

I guess you should take more than three weeks with LiveCode

Hi,

Column Builder's Format, in the Decimal separator. Not In the Pattern property

Thanks for the reply [-hh]. I have usually replaced "," by "." and "." by ",", to make it look good on the screen, and to save it to the database to reverse the operation. According to the lesson on the dgH plugin, this format is correct, but it does not work out for me. http://lessons.livecode.com/...

I have downloaded the DGH trial. I followed the lessons to be able to format a field "### ## 0.00", decimal separator "," and separator of thousands ".". I do not get an error but it does not format it. It can be a limitation of the trial?

Regards,

Carles

Hello, I am following the instructions of the video "Installing Valentina for LiveCode ADK on Mac OS X". I have been following all the steps and when I get to "Check connection using LOG", when debugging the script in "put VDatabase_Constructor (" 127.0.0.1 "," sa "," sa "), hang the LiveCode. Teste...

Hi bogs, I guess I do not explain myself well. I have no problem connecting to databases through LiveCode, the big problem is the topic of accents and diacritics. Supongo que no me explico bien. No tengo problema para conectarme a bases de datos a través de LiveCode, el gran problema es el tema de l...

Hi, I see that MariaDB is more fun to find a configuration that works with LiveCode. This is the only test that I have made of coding, I attach the results: latin1_spanish_ci utf8_spanish_ci Càrlés Bârbal Gönçalves - MariaDB C‡rlÈs B‚rbal GˆnÁalves - Normal Crls Brbal Gnalves - textDecode(text,"UTF-...