Log in/Create an account
to access all forum topics

  • Page:
  • 1

TOPIC:

not able to use mysql 8 ? 14 Apr 2020 09:40 #126

  • Defiled Fraggle
  • Defiled Fraggle's Avatar Topic Author
  • New member
  • New member
    Dormant accounts
  • Posts: 4
  • Thank you received: 0
  • Points: 0.00
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 ^^^ ?

Please Log in or Create an account to join the conversation.

not able to use mysql 8 ? 14 Apr 2020 11:30 #127

  • Cnayl Rainbow
  • Cnayl Rainbow's Avatar
  • Administrator
  • Administrator
    Super Users
  • Posts: 350
  • Thank you received: 228
  • Points: 1269.00
  • Chatty farmer Beta tester
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"

Please Log in or Create an account to join the conversation.

not able to use mysql 8 ? 19 Apr 2020 23:46 #135

  • Defiled Fraggle
  • Defiled Fraggle's Avatar Topic Author
  • New member
  • New member
    Dormant accounts
  • Posts: 4
  • Thank you received: 0
  • Points: 0.00
01:33:43 - [REGION DB]: MySQL error in ExecuteNonQuery: Incorrect string value: '\xE2\x99\x80 \x0A0...' for column `cove`.`prims`.`Text` at row 1

Please Log in or Create an account to join the conversation.

not able to use mysql 8 ? 20 Apr 2020 09:38 #136

  • Cnayl Rainbow
  • Cnayl Rainbow's Avatar
  • Administrator
  • Administrator
    Super Users
  • Posts: 350
  • Thank you received: 228
  • Points: 1269.00
  • Chatty farmer Beta tester
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.

Please Log in or Create an account to join the conversation.

Last edit: by Cnayl Rainbow.
  • Page:
  • 1

hg.osgrid.org:Mintor

hg.osgrid.org:Aquino

hg.osgrid.org:Sandy Island

hg.osgrid.org:Julian Beach

opensim logo

JSN Boot template designed by JoomlaShine.com