I have been working on solving the problems with mysql4.1 and i18n issues. I have commited my changes in rev636. marios, can you please do a fresh install and see wether you have any more issues? I hope you don’t. On my tests everything worked, inluding updating language via RPC. Text on Frontend and Backend displayed correctly.

Explanation: What the changes do is they create utf8 tables if we are on 4.1 and up. They add a config-value to config.php ( $txpcfg['dbcharset'] = 'utf8'; ) and the connection charset is set explicitly to this value for each connection.

For older installations: If (and only if) you are sure that your tables are already created as utf8 (because you manually did that, or your DB defaulted to that) then you can add the previous line to config.php and thus “upgrade” an existing installation (of yourse you also have to replace all other files as well, just do a regular upgrade).

I have also added some stuff to diagnostics when you set high level – there should be a couple of mysql/charset related lines.

@spiros: You are on mysql4.0 (or older). This is not a grave problem, since you can still write and display your posts, it’s just that the db won’t correctly search and order in posts. There are no problems with i18n on mysql4.0 and older, when using latin1-tables.

> Greek characters converted to html entities.

If this happens on the front-end, than this is actually by design. Because not everybody uses utf8 for their websites, Textile converts all characters that are > 0×7f to html entities but only for rendered posts. This is not strictly “necessary” if you are using utf8 headers on the webpage, but it doesn’t hurt either.
Though I understand the desire that Textile behaved differently and we’ll see what we can do about that.

btw: WP will only work correctly if you have 4.0 and lower or the “right” defaults for 4.1 and up. They “get it right” by simply letting it default to whatever and not caring about the db, if I didn’t overlook anything.

marios · 2005-07-27 20:44:54

I have been working on solving the problems with mysql4.1 and i18n issues. I have commited my changes in rev636. marios, can you please do a fresh install and see wether you have any more issues? I hope you don’t. On my tests everything worked, inluding updating language via RPC. Text on Frontend and Backend displayed correctly.

Bingo, verified using 4.1.11 and r637

Sencer, you are such an incredible geek,so how can I pay you back then, at least I owe you a case of beer.
I tell you what, Ill take a break now,and get myself some at the supermarket and toast to your health and TXP,s well-formedness,

With best regards, marios

Last edited by marios (2005-07-27 20:48:08)

Sencer · 2005-07-27 21:04:55

I’m glad it’s working for you! I have to attribute most of that to mamash, zem and you though, since I only put together and bring to an end what all three of you have been figuring out. ;)

marios · 2005-07-27 22:06:43

Well, the geek badges go to you then, Zem and mamash ,

So what about me then, errr,
no good, keep on learning, learning, learning under some sort of circus circumstances.

with best regards, marios

Last edited by marios (2005-07-27 22:07:54)

spiros · 2005-07-27 22:48:05

Marios and Sencer,

Could you please share with us the results? I.e. UTF-8 / Windows-1253 works without creating html or numeric entities and displayes without squares for both IE and Mozilla? Could you also share the latest rev so that I could test its behaviour on my server?

Thanks!

Last edited by spiros (2005-07-27 22:49:35)

Sencer · 2005-07-27 23:14:17

spiros, you are on mysql4.0 or lower, you won’t be seeing much of a difference I suppose. As I tried to explain the creation of the entities is not a bug or error or a necessitiy – it is currently done by design of Textile (the text-formatting used in textpattern).

Though you should not be seeing squares or anything similar (I haven’t after I tried it out on mysql3, mysql4.0 and mysql4.1 with latin1 and utf-8 DB. Always used utf-8 headers on the webpages though.)

If you want to try it out, see here: http://www.sencer.de/code/rev638.zip (temporary, will likely die soon).

marios · 2005-07-27 23:53:12

Spiros, you are encouraged to post your testresults using the code range blocks provided in the initial bugreport, so to ease drawing conclusions.
Allso, display problems at the front End are better verified from page source, to eliminate the more difficult to diagnose browsrer quirk display problems in our testing scenarios.

with best regards, marios

spiros · 2005-07-28 08:48:40

Thanks Sencer ):

Marios, what exactly do you mean by “code range blocks” and how do I use them for testing? Which php version do you run?

So far, even when viewing source I get the same results more or less.

Unfortunately I have CP so I can only go with what my host offers through CP (I know that technically they can upgrade to php 5.04 and MySQL 4.3.11 but this would “break” some applications which do not support it yet).

By the way, does TXP support this server configuration?

Last edited by spiros (2005-07-28 09:09:16)

Sencer · 2005-07-28 09:50:37

> So far, even when viewing source I get the same results more or less.

If you have any problems with either of my two explanations of why this is (currently still) intended behaviour, please ask specific questions so I can go into more detail. Sometimes – after diving to deep into a topic – I tend loose the “view and language” of someone not that deep into it. :)

> By the way, does TXP support this server configuration?

Well, there does not exist a mysql4.3 :) But it does support 3.x, 4.0 and 4.1 and (should) 5.0 .

marios · 2005-07-28 11:37:52

Marios, what exactly do you mean by “code range blocks” and how do I use them for testing? Which php version do you run?

Spiros,on the initial thread I have used three blocks that use greek characters using not tonos, tonos and the third one using greek/coptic UNI code range together with the unallocated/control characters.(No polytonic though yet)
If you cut and past those into your test or example blog site and do publish, you can compare what would you get both on your Life Site and in your backend.
(The forum is UTF enabled and if yur browser displays them correctly then just try them,so to make sure ,all characters get converted well)
Using php 5

BTW.:There is no extra communication going on between me and Sencer,I saw his commitments on the code from my INFORSS headline new feeder,that’s why I posted:“Woderfull Sencer” before he actually had time to reply,just not to nourrish any suspicions.
Everything is publically available here, don’t worry,

With best regards, marios

Last edited by marios (2005-07-28 11:46:01)

spiros · 2005-07-28 18:02:56

Marios:
You mean this one:

Για νά δουμε πώς δουλέβει αυτό τό π�?άγμα. Τά κάνει πα�?σινγκ ά�?αυε σωστά. Ή θα έχο�?με π�?οβλήματα. Πέστε μο�? εσείς. Ρόδα.

I guess I will have to fix the incorrect characters first?

Sencer:
I do not know who wrote it, but I love this (as well as the allusion):
CODE IS POTTERY

):

Last edited by spiros (2005-07-28 18:03:56)

marios · 2005-07-28 18:06:24

I was suggesting this:Greek Alphabet without tonos code range values

Α α Β β Γ γ
Δ δ Ε ε Ζ ζ
Η η Θ θ Ι ι
Κ κ Λ λ Μ μ
Ν ν Ξ ξ Ο ο
Π π Ρ ρ Σ σ
Τ τ Υ υ Φ φ
Χ χ Ψ ψ Ω ω

Greek Alphabet with tonos code range values wherever possible

’Α ά Β β Γ γ
Δ δ Έ έ Ζ ζ
Ή ή Θ θ Ί ί
Κ κ Λ λ Μ μ
Ν ν Ξ ξ Ό ό
Π π Ρ ρ Σ σ
Τ τ Ύ ύ Φ φ
Χ χ Ψ ψ Ώ ώ

Greek and Coptic [0370-03FF]
037 038 039 03A 03B 03C 03D 03E 03F
0 Ͱ ΀ ΐ Π ΰ π ϐ Ϡ ϰ 0
1 ͱ ΁ Α Ρ α ρ ϑ ϡ ϱ 1
2 Ͳ ΂ Β ΢ β ς ϒ Ϣ ϲ 2
3 ͳ ΃ Γ Σ γ σ ϓ ϣ ϳ 3
4 ʹ ΄ Δ Τ δ τ ϔ Ϥ ϴ 4
5 ͵ ΅ Ε Υ ε υ ϕ ϥ ϵ 5
6 Ͷ Ά Ζ Φ ζ φ ϖ Ϧ ϶ 6
7 ͷ · Η Χ η χ ϗ ϧ Ϸ 7
8 ͸ Έ Θ Ψ θ ψ Ϙ Ϩ ϸ 8
9 ͹ Ή Ι Ω ι ω ϙ ϩ Ϲ 9
A ͺ Ί Κ Ϊ κ ϊ Ϛ Ϫ Ϻ A
B ͻ ΋ Λ Ϋ λ ϋ ϛ ϫ ϻ B
C ͼ Ό Μ ά μ ό Ϝ Ϭ ϼ C
D ͽ ΍ Ν έ ν ύ ϝ ϭ Ͻ D
E ; Ύ Ξ ή ξ ώ Ϟ Ϯ Ͼ E
F Ϳ Ώ Ο ί ο Ϗ ϟ ϯ Ͽ F 037 038 039 03A 03B 03C 03D 03E 03F

So you have all the charracters.
(I used Firefox for this1.04,browser set to UTF-8)

Sencer:
I do not know who wrote it, but I love this (as well as the allusion):
CODE IS POTTERY

):

I allso liked this, allso you are most certainly welcome for a ‘physical’ meeting at some point under a ούζο-μεζές scenario

with best regards, marios

(A new forum for greek native users is available )

Last edited by marios (2005-07-28 18:41:43)

Textpattern CMS

Textpattern CMS support forum

#25 2005-07-27 19:22:38

Re:

#26 2005-07-27 20:44:54

Re:

#27 2005-07-27 21:04:55

Re:

#28 2005-07-27 22:06:43

Re:

#29 2005-07-27 22:48:05

Re:

#30 2005-07-27 23:14:17

Re:

#31 2005-07-27 23:53:12

Re:

#32 2005-07-28 08:48:40

Re:

#33 2005-07-28 09:50:37

Re:

#34 2005-07-28 11:37:52

Re:

#35 2005-07-28 18:02:56

Re:

#36 2005-07-28 18:06:24

Re:

Board footer