asian character sets and EE error
Posted: 03 September 2008 04:21 PM   [ Ignore ]  
Research Assistant
Avatar
RankRankRank
Total Posts:  486
Joined  07-12-2005

Further to this thread, I have a client that wants double-byte characters in titles and other custom fields. I didn’t think it would be a problem, indeed, SAEFs seem to be breaking (white page) and in the CP I’m getting “Unable to create valid URL Title for your entry” when I enter, for example, this: 漢字

We’re running:
Build:  20080710
PHP Version 5.2.5
MySQL: 5.0.37-log

These seem to be the MySQL variables that may be related to the issue:

character_set_client     latin1
character_set_connection     latin1
character_set_database     utf8
character_set_filesystem     binary
character_set_results     latin1
character_set_server     latin1
character_set_system     utf8
character_sets_dir     
/usr/local/mysql5/share/mysql/charsets/
collation_connection     latin1_swedish_ci
collation_database     utf8_unicode_ci
collation_server     latin1_swedish_ci

Client needs this stuff running by Tuesday… does anyone have a magic bullet here?

 Signature 

Technology Consulting
Jobs, apartments, working and moving to Spain.

Profile
 
 
Posted: 03 September 2008 05:07 PM   [ Ignore ]   [ # 1 ]  
Moderator
Avatar
RankRankRankRankRankRankRankRank
Total Posts:  32921
Joined  05-14-2004

Alright, so, ExpressionEngine follows the W3C standards for URLs; which includes never using high ascii characters in URLs. 

The difficulty here is that there is no direct translation from those characters to a non-High Ascii equivalent, so ExpressionEngine can not automatically generate a URL Title.

You have a few options here - one is to create your URL Title using normal characters. The other is to create your title the way you did, but then specify the URL title yourself.  Or you could uses standard characters for your title, let it be auto populated, and use a custom field for your specific language title and only output the latter in your templates.

 Signature 
Profile
MSG
 
 
   
 
 
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 1149, on July 16, 2007 09:33 AM
Total Registered Members: 65086 Total Logged-in Users: 34
Total Topics: 82224 Total Anonymous Users: 25
Total Replies: 441923 Total Guests: 204
Total Posts: 524147    
Members ( View Memberlist )