This is the answer that was required but everybody answered only part one of many. Step 1 – You cannot have the multilingual characters in unicode document.. convert the document to UTF-8 document advanced editors don’t make it simple for you… go low level… use notepad to save the document as meName.html & change the … Read more
Web-font for Japanese, though there are few providers exist, is not really practical as you found the size of the font data is too big to download. Usually Japanese font has 8,000-16,000 glyph so making new fonts means you need to make at least 8,000 glyph, which is pretty heavy task. As a result of … Read more
Similar to method 3: [languages] id (int PK) code (varchar) [products] id (int PK) neutral_fields (mixed) [products_t] id (int FK) language (int FK) translated_fields (mixed) PRIMARY KEY: id,language So for each table, make another table (in my case with “_t” suffix) which holds the translated fields. When you SELECT * FROM products, simply … LEFT … Read more
If you’re using the default view engines, then local resources work in the views. However, if you need to grab resource strings within a controller action, you can’t get local resources, and have to use global resources. This makes sense when you think about it because local resources are local to an aspx page and … Read more
Have you seen CodeIgniter’s Language library? The Language Class provides functions to retrieve language files and lines of text for purposes of internationalization. In your CodeIgniter system folder you’ll find one called language containing sets of language files. You can create your own language files as needed in order to display error and other messages … Read more
Yeahh, the “nice name” attributes as you called it was a real “issue” a few month ago. Hopefully this feature is now implemented and is very simply to use. For simplicity i will split the two options to tackle this problem: Global Probably the more widespread. This approach is very well explained here but basically … Read more
Use a separate project with Resources I can tell this from out experience, having a current solution with 12 24 projects that includes API, MVC, Project Libraries (Core functionalities), WPF, UWP and Xamarin. It is worth reading this long post as I think it is the best way to do so. With the help of … Read more
Topic’s premise There are three distinct aspects in a multilingual site: interface translation content url routing While they all interconnected in different ways, from CMS point of view they are managed using different UI elements and stored differently. You seem to be confident in your implementation and understanding of the first two. The question was … Read more
What do you think about having a related translation table for each translatable table? CREATE TABLE T_PRODUCT (pr_id int, PRICE NUMBER(18, 2)) CREATE TABLE T_PRODUCT_tr (pr_id INT FK, languagecode varchar, pr_name text, pr_descr text) This way if you have multiple translatable column it would only require a single join to get it + since you … Read more