Should multiple regional websites all use the same database?

Posted by John Himmelman on Stack Overflow See other posts from Stack Overflow or by John Himmelman
Published on 2010-05-03T18:19:18Z Indexed on 2010/05/08 11:28 UTC
Read the original article Hit count: 147

Filed under:

cms

|

internationalization

I'm developing a cms for a company that has multiple regional sites (us, uk, china, russia, etc..). Should I use a separate database for each of these sites or use a single database with a 'site' field in each table? My main concern is the table language encoding (ie, can storing strings in different langauges in the same table cause problems, such as sorting issues).

© Stack Overflow or respective owner

Related posts about cms

Transitioning from Oracle based CMS to MySQL based CMS

as seen on Programmers - Search for 'Programmers'
We're looking at a replacement for our CMS which runs on Oracle. The new CMSes that we've looked at can in theory run on Oracle, but most of the vendor's installs run off of MySQL vendor supports install of their CMS on MySQL, and a "theoretical" install on Oracle the vendor's dev shops use MySQL none… >>> More
Upgraded Linux, now CMS Made Simple is spewing errors

as seen on Pro Webmasters - Search for 'Pro Webmasters'
I upgraded my host from Debian Lenny to Debian Squeeze, and now my CMS Made Simple site is spewing PHP errors all over the screen. I thought I'd upgrade the CMS because I haven't done so in a while, but Google Chrome tells me that the CMS Made Simple site is infested with malware. What are my options… >>> More
Version control a content management system?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following directory structure in the CMS application we have written: /application /modules /cms /filemanager /block /pages /sitemap /youtube /rss /skin /backend /default /css /js /images /frontend /default … >>> More
Django CMS - not able to upload images through cmsplugin_filer_image

as seen on Stack Overflow - Search for 'Stack Overflow'
i have a problem with a local installation on django cms 2.3.3: i've installed it trough pip, in a separated virtualenv. next i followed the tutorial for settings.py configuration, i started the server. Then in the admin i created an page (home), and i've tried to add an image in the placeholder through… >>> More
Why to build own CMS?

as seen on Stack Overflow - Search for 'Stack Overflow'
On my first job interview, I was asked why did I build my own CMS? Why not to use one of existing CMS, Wordpress, Joomla, Drupal...? At first, I was stunned. I couldn't immediately recall all of my reasons for building my own CMS, but this was definitely one of the main reasons: It's my code and if… >>> More

Related posts about internationalization

GWT Internationalization throws an exception while rebinding

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to internationalize a test application with GWT following the instruction and I have: com.example.client.MyConstants.java com.example.client.MyConstants_en.properties com.example.client.MyConstants_fr.properties com.example.client.MyAppEntryPoint.java In this code I have: public interface… >>> More
Please help with my JSP Internationalization problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with I18N in JSP, specifically, with forms. When I enter some Czech characters (e.g., "ešcržýá...") into my page one form, into the field "fieldOne", and then show text from that field on page two, instead of Czech characters I see this as "ÄÄ". (Note, the second page gets the Czech… >>> More
Internationalization in a website

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear All, I m using ResourceBundle method getBundle(Propertyfilename,Local.languagename) class which returns an object of ResourceBundle of the local rb = ResourceBundle.get Bundle("Locale Strings", Locale.ARABIC);-Not Supported How can i use this to support arabic,band english. >>> More
Internationalization of non-english application

as seen on Programmers - Search for 'Programmers'
I know there are lots of posts for internationalization, but this is something I didn't found while searching. I have a PHP Web application, which is pretty big right now. It's developed actively for 4 years and wasn't built with internationalization in mind. Text is everywhere - in plain HTML, in… >>> More
why Internationalization is shortened to "i18n" ?

as seen on Stack Overflow - Search for 'Stack Overflow'
When people discuss about Internationalization they use the word i18n more often. For first time I didnt get what they are referring at by i18n, then I came to know that its internationalization. So wanted to know how internationalization = i18n? >>> More