International Language in MySQL

[jay711]

I'm trying to set up a Thai web site. However, when save it convert the text from Thai to something like this

พวกวัยรุ่นชอบตีกันน่ะ คนไม่รู้อิโหน่อิเหน่โดนหางเลขประจำ ไม่บาดเจ็บก็เสียชีวิต ล่าสุดได้ข่าวว่าเอาไม้ฟาดคุณยายล้มทั้งยืนเลย.. ไม่ชอบเลย บางครั้งเดิน ๆ


That was a one sentence. The message is safe and get display perfectly. But the topic can't be save because it's too long. So it's only save like

พวกวัยรุ่นชอบตีกันน่ะ &#

which is not even 4 word.

How can I make MySQL save the Thai character instead of this special code. I don't want to exten the topic field length.

Thanks.

[espicom]

Your problem is that the title/subject field is only 60 bytes long in the database, and Thai requires two bytes per character, so it has a 30-character limit.

To fix that, you can use this SQL command:

Code: Select all

ALTER TABLE phpbb_posts_text CHANGE `post_subject` `post_subject` VARCHAR( 254 ) DEFAULT NULL;

That will give you 128 characters to work with.