OpenSim/DB/prims/UTF-8 の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• OpenSim/DB/prims/UTF-8 へ行く。
• OpenSim/DB/prims/UTF-8 の差分を削除

#author("2024-09-02T04:22:37+00:00","default:iseki","iseki")
#author("2024-09-02T04:22:46+00:00","default:iseki","iseki")
** prims テーブルの TextカラムのUTF-8問題 [#k75163e4]

*** Error Message [#w9126ede]
 2023-08-12 20:52:48,996 ERROR [REGION DB]: MySQL error in ExecuteNonQuery: Incorrect string value: '\xE7\xA9\xBA\xE3\x81\x8D...' for column `jogrid_db`.`prims`.`Text` at row 1
 2023-08-12 20:52:48,997 ERROR [SCENE]: Storing of grid user name pole, 1e854de9-143c-4e10-aa14-f42ba4c68e0b in Tempest failed with exception Incorrect string value: '\xE7\xA9\xBA\xE3\x81\x8D...' for column `jogrid_db`.`prims`.`Text` at row 1  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
   at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00026] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
   at MySql.Data.MySqlClient.Driver.GetResult (System.Int32 statementId, System.Int32& affectedRows, System.Int64& insertedId) [0x00000] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
   at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00023] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00205] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00315] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery () [0x00033] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
   at OpenSim.Data.MySQL.MySQLSimulationData.ExecuteNonQuery (MySql.Data.MySqlClient.MySqlCommand c) [0x00024] in <8b4206b9ccaf407f9cb5690f46a27ae5>:0
   at OpenSim.Data.MySQL.MySQLSimulationData.StoreObject (OpenSim.Region.Framework.Scenes.SceneObjectGroup obj, OpenMetaverse.UUID regionUUID) [0x000d5] in <8b4206b9ccaf407f9cb5690f46a27ae5>:0
   at OpenSim.Services.SimulationService.SimulationDataService.StoreObject (OpenSim.Region.Framework.Scenes.SceneObjectGroup obj, OpenMetaverse.UUID regionUUID) [0x00000] in <e4c21485e2f94459bf60ab3b6739a1cb>:0
   at OpenSim.Region.Framework.Scenes.SceneObjectGroup.ProcessBackup (OpenSim.Region.Framework.Interfaces.ISimulationDataService datastore, System.Boolean forcedBackup) [0x00341] in <8777cf221e4544bf893c42f6ef87e7f4>:0
#br

*** 書き込み場所 [#jc102f0e]
- Data/MySQL/MySQLSimulationData.cs
        private void ExecuteNonQuery(MySqlCommand c)
        {
            try
            {
                c.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                m_log.Error("[REGION DB]: MySQL error in ExecuteNonQuery: " + e.Message);
                throw;
            }
        }

*** データ設定場所 [#f46aaeb0]
- /Data/MySQL/MySQLSimulationData.cs: L142辺り
       cmd.CommandText = "replace into prims (" +

*** データ読み込み場所 [#k5e28b23]
- /Data/MySQL/MySQLSimulationData.cs: L350辺り
        SceneObjectPart prim = BuildPrim(reader);
#br