Charset and collation MariaDB with LiveCode

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
cbarbal
Posts: 114
Joined: Fri May 08, 2015 5:04 pm

Charset and collation MariaDB with LiveCode

Post by cbarbal » Mon Sep 17, 2018 7:10 pm

Hi,

After the success of SQLite, post viewtopic.php?f=12&t=31509

I want to do some tests with MariaDB, which comes by default in XAMMP. Someone could advise me the type of Character Set and the one of Collation to use with Catalan and Spanish and that is the maximum compatible with LiveCode.

Thanks in advance.

Carles

capellan
Posts: 654
Joined: Wed Aug 15, 2007 11:09 pm

Re: Charset and collation MariaDB with LiveCode

Post by capellan » Mon Sep 17, 2018 10:15 pm

Hi Carles,

Which results produce the default settings?
https://mariadb.com/kb/en/library/setti ... ollations/

Al
Last edited by capellan on Tue Sep 18, 2018 12:24 am, edited 1 time in total.

bogs
Posts: 5435
Joined: Sat Feb 25, 2017 10:45 pm

Re: Charset and collation MariaDB with LiveCode

Post by bogs » Mon Sep 17, 2018 10:40 pm

Erm, Al for a link you need to format it like this -

Code: Select all

[url=https://mariadb.com/kb/en/library/setting-character-sets-and-collations/]SomeTextHere[/url]
Setting Character Sets and Collations :wink:
Image

capellan
Posts: 654
Joined: Wed Aug 15, 2007 11:09 pm

Re: Charset and collation MariaDB with LiveCode

Post by capellan » Tue Sep 18, 2018 12:23 am

Fixed. Many Thanks, Bogs! :)

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

Re: Charset and collation MariaDB with LiveCode

Post by cbarbal » Tue Sep 18, 2018 12:40 pm

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-8") :o

As what I want to learn is LiveCode, for now I will stop playing to find configurations that work with LiveCode. Personally I think the topic of connection to databases should be easier, for which we have a language that uses accent and diacritics. At the moment, it does not allow me to leave FileMaker.

With MacOX 10.12.6, what works for me:

ODBC with FileMaker. No problem
SQLite created with SQLiteAdmin from lcSQL Software. No problem
SQLite not created with the previous one. textDecode (text, "UTF-8") and it works.

Thanks to everyone who have given their opinion,

Carles

bogs
Posts: 5435
Joined: Sat Feb 25, 2017 10:45 pm

Re: Charset and collation MariaDB with LiveCode

Post by bogs » Tue Sep 18, 2018 2:37 pm

@ Al - always glad if I can help :D

@ Carles - if your looking for information about how to connect to databases from Lc, there are a few ways listed in the lessons that break it down to smaller chunks, such as doing this search on the lessons page -
LiveCode Lessons / Search Results = connection to database


ODBC is right at the top of that list of results. Good luck :)
Image

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

Re: Charset and collation MariaDB with LiveCode

Post by cbarbal » Tue Sep 18, 2018 2:50 pm

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 los acentos y diacríticos.

Thank you very much for your interest, :D

Carles

bogs
Posts: 5435
Joined: Sat Feb 25, 2017 10:45 pm

Re: Charset and collation MariaDB with LiveCode

Post by bogs » Tue Sep 18, 2018 3:25 pm

cbarbal wrote:
Tue Sep 18, 2018 2:50 pm
I guess I do not explain myself well.
I would say it is just as possible that I didn't understand it well :)

The main part I was reading was -
cbarbal wrote:
Tue Sep 18, 2018 12:40 pm
Personally I think the topic of connection to databases should be easier,
... and I didn't connect it to -
cbarbal wrote:
Tue Sep 18, 2018 12:40 pm
for which we have a language that uses accent and diacritics.
... since they seem two different areas to me.

So basically, it seems like your still talking about decoding text pulled from the various DB schemes. My bad :oops:
Image

capellan
Posts: 654
Joined: Wed Aug 15, 2007 11:09 pm

Re: Charset and collation MariaDB with LiveCode

Post by capellan » Tue Sep 18, 2018 4:36 pm

Hi Carles,

Before leaving LiveCode, maybe you could try SQL Yoga,
a Dual License library (AGPL and Commercial):

https://www.bluemangolearning.com/livec ... /sql-yoga/
SQL Yoga extends the simplicity of LiveCode to databases by allowing you to treat your database like an object. Stop wrestling with SQL and see how easy database integration can be:

Set properties rather than writing SQL
Define searches using english words rather than arcane wildcard symbols
Manipulate arrays, not cursors
Easily generate searches from complex search UIs
Tap into database table relationships to simplify code
With SQL Yoga you focus on using your data instead of worrying about accessing your data.


Now, we have 3 different encodings: UTF8 Mac, UTF8 Windows and UTF Linux...
(Carles told me that he is using Xampp within a Linux virtual machine on MacOs X)

Al
UTF8 Mac - UTF8 Windows - Unknown.png

Post Reply

Return to “Databases”