0006911: [SCRIPT] Problem with special chars on text over prim

(0025350)
djphil (reporter)
2014-03-03 17:49

If i add "if (change & CHANGED_REGION_START) [...}" in the script, it is ok else isn't.

Do you consider this as normal ?
If yes, then I'll close this mantis.

(0031452)
djphil (reporter)
2016-12-14 13:31

I did not see any changes with the special characters. They are always replaced by "?" At each simulator restart. This often forces you to force the script to recompile, which is quite compelling, especially if your script contains data that needs to be retained. Would not it be possible to have special characters that always display correctly?

(0031456)
JeffKelley (reporter)
2016-12-14 14:30

Try if (change & CHANGED_REGION_RESTART) llResetScript();

(0031458)
djphil (reporter)
2016-12-14 14:35

I do not need to test this, the problem is elsewhere but ty :)

Special characters are always effective, WITHOUT having to reset your script systematically.

It could be something utf8 database storage issue ...

(0031459)
JeffKelley (reporter)
2016-12-14 14:42

Check encoding for row Text of table prims. Mine is cp1252 (latin1)

(0031581)
Ferd Frederix (reporter)
2017-02-04 17:35
edited on: 2017-02-04 17:36

My Opensim had the database incorrectly set for table [prims] to be equal to CHARSET=latin1m, this should be CHARSET=utf8.

It showed this bug.

After rebuilding it from scratch, it now has utf8. This may be due to having originally built it a long time ago without Mysql being set for utf8

Also check that My.ini in your Mysql folder is set for UTF8 in the mysqld section

[mysqld]
character-set-server = utf8

(0031585)
djphil (reporter)
2017-02-05 06:12
edited on: 2017-02-05 06:13

We are probably not the only ones in this case ...

It would be preferable if the OpenSim update offers an automatic conversion of the latin-1 tables to utf-8, if this is not the case.

The user does not have to do this himself.

Tank's for your interest Jeff and Fred.

For info, my table "prims" is latin1_swedish_ci and in "my.ini", msqld is set to character-set-server = utf8 and collation-server = utf8_general_ci

(0031586)
BillBlight (developer)
2017-02-05 06:48
edited on: 2017-02-05 07:08

Another issue with this is actually also on the viewer side, for instance in some cases it will display correctly on a Windows machine, but not on a mac or linux and vice versa .. It is also seems to be dependent on the charset the target machine is using ..

(0031633)
djphil (reporter)
2017-03-18 11:22
edited on: 2017-03-18 11:24

Today i install a new grid from scratch with master code
from http://opensimulator.org/viewgit/?a=shortlog&p=opensim [^] [^]
Commit 07c39624ef01b1f4cab463ecf86dfcf3dfc790f2
(opensim-0.9.0-1199-g07c3962.zip)

Then i checked table "prims" CHARSET configuration and i see it is latin1
Apparently, as Ferd Frederix says above, it should be utf8
If it should be utf8, then is it possible to correct it in the master code ?

Issue History
Date Modified	Username	Field	Change
2013-12-28 14:37	djphil	New Issue
2013-12-28 14:39	djphil	Steps to Reproduce Updated	View Revisions
2013-12-28 14:43	djphil	Steps to Reproduce Updated	View Revisions
2013-12-28 15:23	djphil	Summary	[SCRIPT] Problem with special chars on text hover => [SCRIPT] Problem with special chars on text over prim
2013-12-28 15:23	djphil	Steps to Reproduce Updated	View Revisions
2014-03-03 17:49	djphil	Note Added: 0025350
2016-12-14 13:31	djphil	Note Added: 0031452
2016-12-14 14:30	JeffKelley	Note Added: 0031456
2016-12-14 14:35	djphil	Note Added: 0031458
2016-12-14 14:42	JeffKelley	Note Added: 0031459
2017-02-04 17:35	Ferd Frederix	Note Added: 0031581
2017-02-04 17:36	Ferd Frederix	Note Edited: 0031581	View Revisions
2017-02-05 06:12	djphil	Note Added: 0031585
2017-02-05 06:13	djphil	Note Edited: 0031585	View Revisions
2017-02-05 06:48	BillBlight	Note Added: 0031586
2017-02-05 06:48	BillBlight	Note Edited: 0031586	View Revisions
2017-02-05 07:08	BillBlight	Note Edited: 0031586	View Revisions
2017-03-18 11:22	djphil	Note Added: 0031633
2017-03-18 11:23	djphil	Note Edited: 0031633	View Revisions
2017-03-18 11:23	djphil	Note Edited: 0031633	View Revisions
2017-03-18 11:24	djphil	Note Edited: 0031633	View Revisions
2017-03-18 11:24	djphil	Note Edited: 0031633	View Revisions
2017-03-18 11:31	djphil	Note Added: 0031634
2017-03-18 11:31	djphil	Note Edited: 0031634	View Revisions
2017-03-18 11:32	djphil	Note Deleted: 0031634

Notes
(0025350) djphil (reporter) 2014-03-03 17:49	If i add "if (change & CHANGED_REGION_START) [...}" in the script, it is ok else isn't. Do you consider this as normal ? If yes, then I'll close this mantis.

(0031452) djphil (reporter) 2016-12-14 13:31	I did not see any changes with the special characters. They are always replaced by "?" At each simulator restart. This often forces you to force the script to recompile, which is quite compelling, especially if your script contains data that needs to be retained. Would not it be possible to have special characters that always display correctly?

(0031456) JeffKelley (reporter) 2016-12-14 14:30	Try if (change & CHANGED_REGION_RESTART) llResetScript();

(0031458) djphil (reporter) 2016-12-14 14:35	I do not need to test this, the problem is elsewhere but ty :) Special characters are always effective, WITHOUT having to reset your script systematically. It could be something utf8 database storage issue ...

(0031459) JeffKelley (reporter) 2016-12-14 14:42	Check encoding for row Text of table prims. Mine is cp1252 (latin1)

(0031581) Ferd Frederix (reporter) 2017-02-04 17:35 edited on: 2017-02-04 17:36	My Opensim had the database incorrectly set for table [prims] to be equal to CHARSET=latin1m, this should be CHARSET=utf8. It showed this bug. After rebuilding it from scratch, it now has utf8. This may be due to having originally built it a long time ago without Mysql being set for utf8 Also check that My.ini in your Mysql folder is set for UTF8 in the mysqld section [mysqld] character-set-server = utf8

(0031585) djphil (reporter) 2017-02-05 06:12 edited on: 2017-02-05 06:13	We are probably not the only ones in this case ... It would be preferable if the OpenSim update offers an automatic conversion of the latin-1 tables to utf-8, if this is not the case. The user does not have to do this himself. Tank's for your interest Jeff and Fred. For info, my table "prims" is latin1_swedish_ci and in "my.ini", msqld is set to character-set-server = utf8 and collation-server = utf8_general_ci

(0031586) BillBlight (developer) 2017-02-05 06:48 edited on: 2017-02-05 07:08	Another issue with this is actually also on the viewer side, for instance in some cases it will display correctly on a Windows machine, but not on a mac or linux and vice versa .. It is also seems to be dependent on the charset the target machine is using ..

(0031633) djphil (reporter) 2017-03-18 11:22 edited on: 2017-03-18 11:24	Today i install a new grid from scratch with master code from http://opensimulator.org/viewgit/?a=shortlog&p=opensim [^] [^] Commit 07c39624ef01b1f4cab463ecf86dfcf3dfc790f2 (opensim-0.9.0-1199-g07c3962.zip) Then i checked table "prims" CHARSET configuration and i see it is latin1 Apparently, as Ferd Frederix says above, it should be utf8 If it should be utf8, then is it possible to correct it in the master code ?

Relationships