Charset and collation MariaDB with LiveCode
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Charset and collation MariaDB with LiveCode
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
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
Re: Charset and collation MariaDB with LiveCode
Hi Carles,
Which results produce the default settings?
https://mariadb.com/kb/en/library/setti ... ollations/
Al
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.
Re: Charset and collation MariaDB with LiveCode
Erm, Al for a link you need to format it like this -
Setting Character Sets and Collations
Code: Select all
[url=https://mariadb.com/kb/en/library/setting-character-sets-and-collations/]SomeTextHere[/url]
Re: Charset and collation MariaDB with LiveCode
Fixed. Many Thanks, Bogs!
Re: Charset and collation MariaDB with LiveCode
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")
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
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")
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
Re: Charset and collation MariaDB with LiveCode
@ Al - always glad if I can help
@ 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
@ 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
Re: Charset and collation MariaDB with LiveCode
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,
Carles
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,
Carles
Re: Charset and collation MariaDB with LiveCode
I would say it is just as possible that I didn't understand it well
The main part I was reading was -
... and I didn't connect it to -
... 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
Re: Charset and collation MariaDB with LiveCode
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/
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
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