SilentK
4-16-05, 08:26 PM
I was reading on the vbulletin.com board that it was suggested that in mysql 4.1 you have to specifiy the charset in your queries. Here's the post someone made
I'm no mysql expert, but had similiar problems with 4.1x and had to revert back to 4.0x. The issue then was the Mysql character-set that's new with Mysql 4.1x series. If the character-set isn't defined in the queries in Mysql 4.1x it'll revert to default character/set, which IIRC, is latin-1/swedish.
To correct it probably is to recode the database tables to define the character-set, like with this line....
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
On a default board it could be done easier with an editor to add the above line (with the appropriate charset) in the ./install/mysql_schema.sql file. Every CREATE TABLE query will need that line at the end. It tells mysql what charset to read/write too. If not done, it can "burp" the install process.
Looking at vB's default schema it doesn't include the charset. Mysql 4.1x users will have to add it themselves.
Chris
can anyone confirm this?
I'm no mysql expert, but had similiar problems with 4.1x and had to revert back to 4.0x. The issue then was the Mysql character-set that's new with Mysql 4.1x series. If the character-set isn't defined in the queries in Mysql 4.1x it'll revert to default character/set, which IIRC, is latin-1/swedish.
To correct it probably is to recode the database tables to define the character-set, like with this line....
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
On a default board it could be done easier with an editor to add the above line (with the appropriate charset) in the ./install/mysql_schema.sql file. Every CREATE TABLE query will need that line at the end. It tells mysql what charset to read/write too. If not done, it can "burp" the install process.
Looking at vB's default schema it doesn't include the charset. Mysql 4.1x users will have to add it themselves.
Chris
can anyone confirm this?