Changing charater set in mysql

If we have stored the values in the tables in other languages than english then while selecting use this mysql query to convert the charset
"SET CHARACTER SET 'utf8'"

Zen Cart -linking a static page created with EZ pages

use the following function to link the page created with ez pages
PHp code echo zen_ez_pages_link(page ID, chapter number, page is SSL [true/false], open new window [true/false], return full url [true/false]); EO PHPCODE

i found this link usfull

http://tutorials.zen-cart.com/index.php?article=251

http://tutorials.zen-cart.com/index.php?article=234

http://tutorials.zen-cart.com/index.php?article=117

Word Wrap in css breakwords using css divs and using truncate function of zencart

Hi
if there is long word (with no space) it will cause the layout of the site look ockward use the css style mentioned below to solve this issue
position:relative;margin-top:10px; width:600px; overflow:hidden; word-wrap:break-word;

Zencart truncate function zen_trunc_string($stores->fields['pages_html_text'],400)