Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
Old 09-09-2007, 02:14 PM utf8 and mysql
Junior Talker

Posts: 2
Trades: 0
Hello,
I want a good forum and i tried Invision Power Board (IPB) and vBulletin.
Both of them appears to have problem with utf8 encoding and Greek characters.
Although that the forums are working pretty good when i browse the mysql tables with phpMyAdmin i cant see Greek characters.
I changed from AdminCP of IPB the encoding to utf8.
I deleted from AdminCP of vBulletin the Blank Character Stripper.
The database is utf8_general_ci. The tables are also utf8_general_ci.
I have php 5.
Am i missing something here?
Attached Images
File Type: gif ipbchar.gif (14.5 KB, 3 views)
File Type: gif vbchar.gif (17.5 KB, 3 views)
blackpr is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 09-10-2007, 04:21 AM Re: utf8 and mysql
Christopher's Avatar
Iced Cap

Latest Blog Post:
Cross-domain AJAX with JSONP
Posts: 3,110
Location: Toronto, Ontario
Trades: 0
What charset are the forum pages being served in? If your site is serving visitors up iso-8859-7 pages for example, then they may be submitting content to the scripts in that charset. Remember that the bits for non-ASCII characters may be different in UTF-8 than they are in other charsets.

Both forums will have a way to change the charset, probably a per-language setting. Make sure the charset for the lang is UTF-8.

The reason they will work on the forums is because the forum script will be telling the browser the correct charset, which means the bits will match up with the correct characters. Then when you hop into phpMyAdmin, it is telling the browser that the charset is UTF-8, and the bits don't match the correct characters.

The charset/coalation in MySQL is only used when you perform string operations in a query. It has nothing to do with the actual content (in the database, strings are still just bits of data). It is how you use the strings (ie., what charset you send to the client) that determines which characters show up.
__________________

Please login or register to view this content. Registration is FREE
- Latest Articles:
Please login or register to view this content. Registration is FREE
,
Please login or register to view this content. Registration is FREE

--
Please login or register to view this content. Registration is FREE

Christopher is offline
Reply With Quote
View Public Profile
 
Old 09-14-2007, 11:45 AM Re: utf8 and mysql
Junior Talker

Posts: 2
Trades: 0
Thank you for this explanation but the pages are served in utf8 encoding.
blackpr is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to utf8 and mysql
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.34050 seconds with 13 queries