Jose Manuel Barrueco writes
If nobody has comments or suggestion on that I would suggest to go ahead with the change latin-1 to utf8. If we proceede like in CitEc it should not be necesary to reload all citations since the proporcion of references afected is quite small...
I have the following log of a skype chat with Ivan. He seems to think that the change should be done. da? meaning we can change the colon type [5:12:44 PM] Иван В. Курманов: hi Thomas [5:12:50 PM] Иван В. Курманов: :) [5:13:05 PM] Иван В. Курманов: since you asked... [5:13:13 PM] Иван В. Курманов: it should be in utf 8 already [5:13:24 PM] Thomas Krichel: it is not [5:13:25 PM] Иван В. Курманов: it should have been in utf8 from the start [5:13:29 PM] Иван В. Курманов: how do you know? [5:13:39 PM] Thomas Krichel: we looked it up in phpmyadmin [5:13:55 PM] Иван В. Курманов: ok [5:14:07 PM] Иван В. Курманов: but that's just the mysql type [5:14:34 PM] Иван В. Курманов: it matters for comparisons and string functions [5:14:37 PM] Thomas Krichel: JMBC was amazed taht you turned his latin-1 to utf-8 somehowe [5:14:49 PM] Иван В. Курманов: ? [5:15:25 PM] Thomas Krichel: you took his latin-1 in amf, and made it somewho utf-8 [5:15:33 PM] Thomas Krichel: we did not see a conversion. [5:16:02 PM] Иван В. Курманов: did he put latin-1 in AMF? did it have <?xml declaration with encoding='latin-1' ? [5:16:10 PM] Thomas Krichel: no [5:16:14 PM] Thomas Krichel: apparently not [5:16:28 PM] Thomas Krichel: the whole thing is very strange. [5:17:27 PM] Thomas Krichel: I don't want to bother you with this, because this is not an emmergency, so I think we can just cange the type and see what comes out. [5:17:48 PM] Thomas Krichel: I will also check the acis code that creates the tables. [5:18:03 PM] Иван В. Курманов: the fact that something in ACIS database does not have UTF8 type is wrong, but I don't think it is responsible for any real trouble you are having [5:18:31 PM] Thomas Krichel: no, the origin was latin-1 from jmbc [5:18:46 PM] Иван В. Курманов: i might be wrong, (as things change), but this type does not by itself causes any charset conversion [5:18:59 PM] Thomas Krichel: correct. [5:19:12 PM] Thomas Krichel: but it will convert if you change the colon type [5:19:18 PM] Thomas Krichel: I think. [5:19:35 PM] Иван В. Курманов: i doubt; re-check that [5:20:05 PM] Thomas Krichel: I don't know how to check ,but the query took a very long time to run when we made the change on mutabor. [5:20:14 PM] Thomas Krichel: so it must have been converting something. [5:20:31 PM] Иван В. Курманов: "I don't know how to check" -- documentation [5:21:11 PM] Thomas Krichel: I know I have to lookup the docementation. I have not seen it in there last time I looked, but I did not investigate. [5:21:38 PM] Иван В. Курманов: in this case I meant the mysql database [5:22:07 PM] Иван В. Курманов: which would definitely answer if the data conversion takes place if you change the column charset [5:23:10 PM] Thomas Krichel: I know you mean the database. [5:23:23 PM] Thomas Krichel: I am not sure what command phpmyadmin runs. [5:26:15 PM] Thomas Krichel: one think for sure is that under latin-1 the column does not take the utf-8 output that JMBC produces now. [5:26:43 PM] Thomas Krichel: I think we can close the matter here so far. [5:26:52 PM] Thomas Krichel: I hope you are doing fine. [5:27:07 PM] Иван В. Курманов: alright. thanks, Thomas, I'm ok I suggest that JMBC proceeds monday morning, I will be at hand monday to watch out for problems. Cheers, Thomas Krichel http://openlib.org/home/krichel RePEc:per:1965-06-05:thomas_krichel skype: thomaskrichel