XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / mysql 4.1.7 and utf8 problem
Register
21
irmtfan
Re: mysql 4.1.7 and utf8 problem

  • 2005/1/19 7:09

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


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?

http://dev.mysql.com/doc/mysql/en/Charset-conversion.html

good luck in your covnersion :)
22
franfran
Re: mysql 4.1.7 and utf8 problem

  • 2005/1/19 7:28

  • franfran

  • Just popping in

  • Posts: 21

  • Since: 2004/2/10


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?
23
franfran
Re: mysql 4.1.7 and utf8 problem

  • 2005/1/19 7:40

  • franfran

  • Just popping in

  • Posts: 21

  • Since: 2004/2/10


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)
« 1 2 (3)

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

156 user(s) are online (99 user(s) are browsing Support Forums)

Members: 0

Guests: 156

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits