Foreign language character sets
2 posts by 2 authors in: Forums > CMS Builder
Last Post: February 2, 2009 (RSS)
By vl4899 - January 31, 2009
Can CMS Builder handle different character sets? I am trying to implement a Cyrillic character set. I know that MySQL handles it, but when I enter Cyrillic into a record using CMS Builder and save it, the result comes back as question marks.
Re: [vl4899] Foreign language character sets
By Dave - February 2, 2009
Hi vl4899, welcome to the CMS Builder forum! :)
I was able to reproduce that issue. It was a tricky one to track down the cause. Looks like when we're setting the character set for MySQL it was resetting another value incorrectly. I've fixed it for the next release and you can add it yourself with these changes:
- Open /lib/database_functions.php
- Search for this: mysql_query("SET CHARACTER SET
- Add a comment (in red) to this line:
# mysql_query("SET CHARACTER SET 'utf8'") or die("MySQL Error: " .mysql_error(). "\n");
Let me know if that works for you.
I was able to reproduce that issue. It was a tricky one to track down the cause. Looks like when we're setting the character set for MySQL it was resetting another value incorrectly. I've fixed it for the next release and you can add it yourself with these changes:
- Open /lib/database_functions.php
- Search for this: mysql_query("SET CHARACTER SET
- Add a comment (in red) to this line:
# mysql_query("SET CHARACTER SET 'utf8'") or die("MySQL Error: " .mysql_error(). "\n");
Let me know if that works for you.
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com