Database with accents and diacritics

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, kevinmiller

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 6232
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles
Contact:

Re: Database with accents and diacritics

Post by FourthWorld » Sat Sep 29, 2018 9:57 pm

cbarbal wrote:
Fri Sep 28, 2018 7:47 pm
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 áéíóú çñ ÑÇ
TextEncode is merely the name of the function. Its output is dependent on its params. What does your code look like?
Richard Gaskin
Community volunteer LiveCode Community Liaison

LiveCode development, training, and consulting services: Fourth World Systems: http://FourthWorld.com
LiveCode User Group on Facebook : http://FaceBook.com/groups/LiveCodeUsers/

cbarbal
Posts: 98
Joined: Fri May 08, 2015 5:04 pm

Re: Database with accents and diacritics

Post by cbarbal » Sun Sep 30, 2018 10:02 am

HI Alejandro,

I use XAMPP-VM / PHP 7.2.10 in MacOs. In the control panel from XAMPP there is a tab called "Volumes" with the buttons "Mount", "Unmount" and "Explore", I give Mount and mount the volume on the desktop. I open it, double click on the "etc" folder and modify the "my.cnf" file, that's all. I have not touched anything else, I hope it helps you
Finder001.jpg
Now it works perfect,

Carles

cbarbal
Posts: 98
Joined: Fri May 08, 2015 5:04 pm

Re: Database with accents and diacritics

Post by cbarbal » Sun Sep 30, 2018 10:26 am

Hi Richard,

I enclose a screen with the entry from the individual LiveCode fields and the result in the dataGrid. The number 4 is the same entry as 5, before modifying the "my.cnf" file.
LiveCode001.jpg
The searches also work.

Now the idea is to make three applications, one that is connected by ODBC to FileMaker, which was already started and was the only one that did not give me input problems. Another, also started, with SQLite, which had already taken the trick to the accents thanks to "Jaquelin". And the last, which almost forces me to throw in the towel, with MariaDB. SQLite and MariaDB, will be the same replica of the FileMaker original.

Regards,

Carles

Post Reply

Return to “Databases”