| Re: mysql 4.1.7 and utf8 problem |
| by franfran on 2005/1/19 7:40:16 irmtfan, FINALLY! I opened xoops/class/database/mysqldatabase.php under the function connect: + mysql_query("SET CHARACTER SET utf8", $this->conn); There is no need to do table charset convertion as I was using utf8 previously in 4.1.0. Once again, Thank you!!!  The only thing left is why 4.1.7 not working with the smarty code? I really don't know, but I think XOOPS core dev. should look into it(if they are interested to dig) |
| Re: mysql 4.1.7 and utf8 problem |
| by franfran on 2005/1/19 7:28:00 I was using utf8 in 4.1.0 already. I need to do the convertion again after moved to 4.1.9? May I ask you irmtfan, you are using 4.1.x with utf8 currently? |
| Re: mysql 4.1.7 and utf8 problem |
| by irmtfan on 2005/1/19 7:09:06 franfran , for convert collation first you must set the column as binary to avoid corrupting characters. i have this problem and ackbarr guide me with this: Quote: Have you tried converting the columns themselves to holding UTF-8 characters? good luck in your covnersion :) |
| Re: mysql 4.1.7 and utf8 problem |
| by franfran on 2005/1/19 5:27:16 Just some update: XOOPS + 4.1.7(utf8 charset/utf8_general_ci collation): Result: all modules(blocks) content will become blank. Don't know reason why. XOOPS + 4.1.8/9(utf8 charset/utf8_general_ci collation): Result: XOOPS working normally. It is NOT a matter of either using XAMMP or install MYSQL/PHP individually, i.e. not config files related problem. Thanks irmtfan, you gave me a clue on upgrading the MYSQL. And somehow it was my fault, since I upgrade to 4.1.7 in Dec. I don't expect they will release up to 4.1.9 in Jan.(so quick), so I didn't go to mysql.com. If I notice 4.1.8/9 was released, I should have try this upgrade route at the very beginning. Thanks m0nty and irmtfan.  p.s. I tried to move my db(utf8) from 4.1.0 to 4.1.9 now. The blocks are working fine now, however, all charactes become ???. But anyways, it maybe another issue. I will figure out later on. |
| Re: mysql 4.1.7 and utf8 problem |
| by irmtfan on 2005/1/18 19:08:26 i dont think there is a bug in MySQL 4.1.7 and it seems XOOPS is not compatible with it in multi-bytes charset. do you try to install another cms and see the result e.g. mambo or xaraya? |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|