Every works fine! ^ ^
Seriously, I don't know why this bother me so much...but it does.
It's a doubt still unresolved, and I think it's time to resolve it.
I had a vb3 forum, utf8...and then I upgrade it to vb4.
Then some nasty things happens, but with impex and luck I got a perfectly fine utf8 installation of vb 4.0.0
Everything works, the Spanish translation works too with accents and eñes...
...and then some time later the vb 4.0.4 was released, and I upgrade to it.
But the forum was a mess! Every accent and eñe was some kind of estrange symbols, so I started playing with the language options.
When I set the language to ISO-8859-1, everything started to be readable again.
So I left the language that way, and everything works again....and everyone was happy.
Everyone minus me.
Because I don't know why it works that way!
I want the forum to be UTF-8 and not ISO-8859-1. I had some issues with that in the past, and I know somewhere in the future this will backfire to me.
And now, looking into the database I see this: The thread field of my mysql Its encoded with latin1_swedish_ci, like some other field, but the majority its encoded with UTF-8.
Maybe that's the reason behind the the symbol problems if I set UTF-8 into the language. Maybe if the thread text aren't encoded with UTF-8, when the browser load that information It does expecting it to be into the right code, and so it shows the text wrong.
So, why before the vb 4.0.4 upgrade the text shows itself right with UTF-8, and after it shows wrong? What was the change?
Maybe I need to encode the latin1_swedish_ci fields with UTF-8? But, how?
I searched for that, and find this: http://mansurovs.com/tech/converting-vbulletin-to-utf-8
But everything works without UTF-8 just fine...
Seriously, I don't know why this bother me so much...but it does.
It's a doubt still unresolved, and I think it's time to resolve it.
I had a vb3 forum, utf8...and then I upgrade it to vb4.
Then some nasty things happens, but with impex and luck I got a perfectly fine utf8 installation of vb 4.0.0
Everything works, the Spanish translation works too with accents and eñes...
...and then some time later the vb 4.0.4 was released, and I upgrade to it.
But the forum was a mess! Every accent and eñe was some kind of estrange symbols, so I started playing with the language options.
When I set the language to ISO-8859-1, everything started to be readable again.
So I left the language that way, and everything works again....and everyone was happy.
Everyone minus me.
Because I don't know why it works that way!
I want the forum to be UTF-8 and not ISO-8859-1. I had some issues with that in the past, and I know somewhere in the future this will backfire to me.
And now, looking into the database I see this: The thread field of my mysql Its encoded with latin1_swedish_ci, like some other field, but the majority its encoded with UTF-8.
Maybe that's the reason behind the the symbol problems if I set UTF-8 into the language. Maybe if the thread text aren't encoded with UTF-8, when the browser load that information It does expecting it to be into the right code, and so it shows the text wrong.
So, why before the vb 4.0.4 upgrade the text shows itself right with UTF-8, and after it shows wrong? What was the change?
Maybe I need to encode the latin1_swedish_ci fields with UTF-8? But, how?
I searched for that, and find this: http://mansurovs.com/tech/converting-vbulletin-to-utf-8
But everything works without UTF-8 just fine...