FUDforum: How To » mysql character set

Home » FUDforum » How To » mysql character set

Show: Today's Messages :: Polls :: Message Navigator

mysql character set [message #29086]

Mon, 28 November 2005 23:11

NoName

Messages: 4
Registered: November 2005
Location: Slovenia

Karma: 0

Junior Member

i'm trying to use an alternative character set with fudforum 2.7.3. on a fresh install i copied folder/thm/default/i18n/english to folder/thm/default/i18n/slovenian and changed the following:
charset: ISO-8859-2
locale: sl_SI.iso88592

and then changed the default theme in admin cp
Template Management
Theme Manager
[Edit]
and so i set it to the slovenian, then updated
and clicked
[Rebuild Theme]
just in case...

when i checked html source it seemed okay (except there's and endline after the charset)

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-2
">

well.. the problem is when i try to change the test category and forum. instead of letters i get questionmarks.
my my.cnf should be okay...

[mysqld]
default-character-set   = latin2
...

is there something i forgot?

and also...

...
1271: Illegal mix of collations for operation ' IN '
Query: INSERT INTO fud26_index (word_id, msg_id) SELECT id, 7 FROM fud26_search WHERE word IN('sestanek','moram','reči'...

when i try to rebuild search index

Report message to a moderator

Re: mysql character set [message #29087 is a reply to message #29086]

Mon, 28 November 2005 23:31

NoName

Messages: 4
Registered: November 2005
Location: Slovenia

Karma: 0

Junior Member

i hate to reply to my own posts but..

BAZA="xxx" for i in ` echo SHOW TABLES | mysql $BAZA | grep -v ^Tables_in_$BAZA`; do echo ALTER TABLE $i CONVERT TO CHARACTER SET latin2\;; done| mysql $BAZA

did the trick

Report message to a moderator

Re: mysql character set [message #29090 is a reply to message #29087]

Mon, 28 November 2005 23:50

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

This is now an admin control panel available for changing charsets of tables.

FUDforum Core Developer

Report message to a moderator

Re: mysql character set [message #29091 is a reply to message #29090]

Tue, 29 November 2005 00:22

NoName

Messages: 4
Registered: November 2005
Location: Slovenia

Karma: 0

Junior Member

where exactly? i couldn't find it Rolling Eyes

Report message to a moderator

Re: mysql character set [message #29093 is a reply to message #29091]

Tue, 29 November 2005 04:18

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

It was added to CVS this morning.

FUDforum Core Developer

Report message to a moderator

Re: mysql character set [message #29097 is a reply to message #29086]

Tue, 29 November 2005 10:22

NoName

Messages: 4
Registered: November 2005
Location: Slovenia

Karma: 0

Junior Member

actually the code doesn't work Rolling Eyes

there's a typo (one ; is missing)
BAZA=x; for i in `echo SHOW TABLES | mysql $BAZA | grep -v ^Tables_in_$BAZA`; do echo ALTER TABLE $i CONVERT TO CHARACTER SET latin2\;; done | mysql $BAZA
hope you saw the error and corrected it

Report message to a moderator

Previous Topic:	óÁÊÔ ÒÕÓÓËÏÊ ÐÏÄÄÅÒÖËÉ...
Next Topic:	permanent signature in usenet messages?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 23:15:18 GMT 2024

Total time taken to generate the page: 0.04994 seconds