not able to use mysql 8 ?

  • a Guest
  • Auteur du sujet
Plus d'informations
14 Avr 2020 09:40 #126 par a Guest
not able to use mysql 8 ? a été créé par a Guest
seems everytime I use mysql 8 I get byte errors when the animals go to save

utf8mb4 collations — The idea is to change the default character set from latin1 to utf8mb4, and the default collation from latin1_swedish_ci to utf8mb4_unicode_ci_ai. UTF8 is the dominating character encoding for the web(supporting 4-Byte UTF-8 characters / emoji into your Database), and this move will make life easier for the vast majority of MySQL users. These are great news and one step ahead towards standardized multilingual support in data driven applications.

is this why ^^^ ?

Connexion ou Créer un compte pour participer à la conversation.

  • Admin
Plus d'informations
14 Avr 2020 11:30 #127 par Admin
Réponse de Admin sur le sujet not able to use mysql 8 ?
I found out recently that there is this issue because by default the animals have the male and female symbol as part of the float text and this does need the database to be (I believe) utf8 for it to save them okay - I seem to recall something being written somewhere about issues with this and mysql 8. Switching to mariaDB has been suggested by some as a solution.

Another solution that has been found to work on a mysql 8 system is to set the float text to None and then restart the region. That seems to save the animal okay even if you then turn the float text back on. But also the new animal script (version 4 onwards) supports multi-language and if you look in the notecard en-GB-langA1 (or whichever language you use) you can change it to use a non-unicode character (such as M and F) e.g.
TXT_FEMALE_SYMBOL = "F"
TXT_MALE_SYMBOL = "M"

Connexion ou Créer un compte pour participer à la conversation.

  • a Guest
  • Auteur du sujet
Plus d'informations
19 Avr 2020 23:46 #135 par a Guest
Réponse de a Guest sur le sujet not able to use mysql 8 ?
01:33:43 - [REGION DB]: MySQL error in ExecuteNonQuery: Incorrect string value: '\xE2\x99\x80 \x0A0...' for column `cove`.`prims`.`Text` at row 1

Connexion ou Créer un compte pour participer à la conversation.

  • Admin
Plus d'informations
20 Avr 2020 09:38 - 20 Avr 2020 09:46 #136 par Admin
Réponse de Admin sur le sujet not able to use mysql 8 ?
Not sure what 'cove' is but as I understand it the 'Text' bit is probably the issue and that could be because of the use of uni-code characters as mentioned above. If possible I would suggest either downgrading mysql or switching to mariadb.
Dernière édition: 20 Avr 2020 09:46 par Admin.

Connexion ou Créer un compte pour participer à la conversation.

donate

hg.vivosim.net:8002:Mintor

hg.vivosim.net:8002:Lugo

hg.vivosim.net:8002:Sandy Island

hg.vivosim.net:8002:Julian Beach

opensim logo