For mysql, this works to set UTF-8 so no changes are needed to the
create database commands. Perhaps it is relevant to Mariadb?
in My.ini:
[mysqld]
character-set-server=utf8
regards:
Fred Beckhusen
[email protected]
On 2019-01
Today's Topics:
1. Re: General voice issue (Jeff Kelley)
2. Re: Fresh standalone install wants table.GridUser (Peter Petroff)
3. Re: Fresh standalone install wants table.GridUser (Jeff Kelley)
----------------------------------------------------------------------
Message: 3
Date: Thu, 24 Jan 2019 09:31:19 +0100
From: Jeff Kelley<[email protected]>
To:[email protected]
Subject: Re: [Opensim-users] Fresh standalone install wants
table.GridUser
Message-ID:<p06240818d86f2762d0f0@[192.168.0.7]>
Content-Type: text/plain; charset="us-ascii" ; format="flowed"
At 1:10 PM +1000 1/24/19, Peter Petroff wrote:
I'm afraid it doesn't seem to help; that seems to be about a plugin
failing to load and its failure crashing other things.
https://forum.metrogrid.de/discussion/4848/mysql-issue-when-running-simulator-on-debian
Quote.
One issue I'm aware of with Diva and MariaDB (default mysql on Debian
9) is a missing GridUser table.
The problem is, that MariaDB uses the utf8mb4 character set per
default when you create the table, but the table has been designed
for the utf8 character set which uses less bytes. while utf8 needs
one to three bytes per character, utf8mb4 needs 4 bytes per character.
Given the defined length of 255 characters for the UserID, which is
the primary key, this results in more than the maximum length of 767
bytes for the primary key when used with the utf8mb4 character set.
The solution is simple: create the database with utf8 as the default
character set.
MariaDB [(none)]> create database opensim character set = 'utf8'
collate = 'utf8_general_ci';
End quote.
------------------------------
_______________________________________________
Opensim-users mailing list
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
End of Opensim-users Digest, Vol 56, Issue 22
*********************************************
_______________________________________________
Opensim-users mailing list
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
