Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Internationalization (v4)
 Same DB with Multiple Language Forums
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

n/a
deleted

593 Posts

Posted - 07 June 2002 :  02:39:56  Show Profile
I noticed in General Topic forum on the subject of two forums with same db -
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=29290

In there, it is mentioned:
to have 2 forums share a database, you just need to change 2 lines in the config.asp file of the second forum:

forum #1's config.asp:
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"

forum #2's config.asp:

strTablePrefix = "FORUM2_"
strMemberTablePrefix = "FORUM2_"

Doing it this way, you can use the same database for both forums. No data will be shared between each of them.

If you want to share the Members table then:

forum #2's config.asp:

strTablePrefix = "FORUM2_"
strMemberTablePrefix = "FORUM_"

-----
Question: Can this approach be used for multiple locale language forum but using same DB?

Don't believe this is exactly the approach V4.x is taking with multiple languages...Or is this basically how V4.x handle multiple languages?

Can you assign Form1 to English, Forum2 to Langxxxxx, Forum 3 to Langyyyy, using the above mentioned approach, but using the same database/serving out of the same database? How do you set a language selector and link in this mode, if that's feasible?

Thanks,


Taku
i2Asia
<

n/a
deleted

593 Posts

Posted - 11 June 2002 :  01:30:32  Show Profile
Sort of tried this, but not quite sure whether I did it right. Probably not, as it didn't work. Using V4.x with English_US only but enabled for posting in multi-language. This satisfy my immediate interest. No urgency for getting a feedback/reply to the above. Thanks.

Taku
i2Asia
<
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 11 June 2002 :  07:54:46  Show Profile
quote:

Question: Can this approach be used for multiple locale language forum but using same DB?

Don't believe this is exactly the approach V4.x is taking with multiple languages...Or is this basically how V4.x handle multiple languages?

Can you assign Form1 to English, Forum2 to Langxxxxx, Forum 3 to Langyyyy, using the above mentioned approach, but using the same database/serving out of the same database? How do you set a language selector and link in this mode, if that's feasible?



You can absolutely do this and each forum can have multiple languages, you can devide western/eastern languages for example. But the contents are different because they are in different tables.

v4b03.x does not have two different table sets, it just uses single or multiple langpacks. If you include them into config.asp, the simple code in language files "register" them to the system by putting the data into an array and the language selector is shown from that array. In v4b04 we will have a different approach as most of the locale specific data will come from another (new) table.

In v3.4 we will have a new feature which will group categories/forums at another upper level: The Group Categories MOD is implemented in v3.4. So you will be able to switch between the groups using a selector.

The method you will prefer will purely depend on what you are trying to do. Having multiple forums (your Q) may have some performance hit thou.


Think Pink
==> Start Internationalization Here<
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 11 June 2002 :  07:59:02  Show Profile
quote:

Sort of tried this, but not quite sure whether I did it right. Probably not, as it didn't work. Using V4.x with English_US only but enabled for posting in multi-language. This satisfy my immediate interest. No urgency for getting a feedback/reply to the above. Thanks.

Taku
i2Asia




Don't forget to set this const to TRUE:

Const blnLangSupport = True
' Controls Multi Language Support and the selector in menu. Default: FALSE


Think Pink
==> Start Internationalization Here<
Go to Top of Page

n/a
deleted

593 Posts

Posted - 12 June 2002 :  05:03:20  Show Profile
Hi Bozden,
Thanks for the info. It's very good to know how future versions are desgined...pretty cool. Also, it is good to know a flexibility in Snitz to be able to customize it. Multiple forums in multiple languages for now is overkill and obviously performance issue will be the problem - although maybe interesting for benchmarking performance itslef. As mentioned, as for now, I have one forum in English_US only, but can handle whatever language contents, so any individual forums/topics can be done in any language. Also because of EC's UI issue, having English1033 only works well.

BTW, let's say you have two forums (multilingual) with a single databae (ACCESS2000), and can have one in unicode and other in OSI encoding? Doesn't seem so with current V4b03.x, since you use same langxxxxx for both forums, whose codepage is set to ISO or unicode.

Anyway, thanks. It's a good stuff.

Taku
i2Asia
<
Go to Top of Page

n/a
deleted

593 Posts

Posted - 24 June 2002 :  16:46:08  Show Profile
I just screwed up setting up a multiple forum using a single DB...couldn't setup separate tables correctly...and getting a real quick re-learning on re-installation and re-build of a forum... So, theoretically, I believe it is a good way to have forums in such a way, if: you want to have totally different forums (with different lang or lang combs) serving out of one DB.... You have to do some upfront thinking on forum designs....or what you want in your forums.

Again, it really depend on what you want and depending on your design consideration. Since you mentioned my "now being revamped in process" forum, I would explain why I am doing that way and why I chose a particular approach.
1. I wanted to have a multilingual forum (not separate locale languge forum) where you can see a selective group of languages deployed in the forum or any additional in the same web page or forum page... so if someone is putting a forum/topic/message in English, Japanese, Chinese, Korean, etc. they all show up correctly in the forum at the same time.
2. For that, I chose V4.x (International Version) over V3.x because it is internationalized to handle locale languages and contents.
3. For having various languages represented/displayed and viewable without switching codepages (this is more on a browser encoding setting issue), I decided to use unicode, which is at present perhaps the best way to handle globalized contents/multilingual enviornment.
These are two basic items I looked at. Here are some thought that you have to give further:
1. Do you want to have all different languages you mentioned rendered correctly at the same time? (seems so)
2. Do you want to have each individual locale language specific forum only, meaning, having multile forums with individual locale language as a default or primary language per forum? (seems so as well)

If your interest is to have multiple languages shown, rendered simultaneously at the forum, I suggest that you use unicode based codepage for each language file. If you are interested in doing indivudal locale language forum, then, you can use V4.x with respective language packs. V4.x allows (by means of a language selector for deployed languages) your visitor/member to select a prefered language. (For properly viewed in html representation and in borwser rendering, you have to choose a browser encoding of a choice to view it properly in a respective language. This is slightly a different item than choosing/setting a codepage in your program language file, which basically is preparing/packaging text information to be viewed/displayed properly in a particular format in html/browser.) Installing V4.x is quite easy.

Given you will use V4.x, then, you have additional considerations:
Setting up a forum with particular language. There are two ways you can do this at present with V4.x. (1) Create language specific forums in your forum - can be for all visitors, members only, etc. - have them in a single master forum - either as an individual category (such as German Forum, then have various forum topics in it.) This case, you will have them all show up in a forum, but manage as done with Snitz for managing various forums, perhaps assign individual language moderators to a particular language forum. (2) Create separate language specific forum (like serving 2 forums out of a single DB mentioned here) where you will default each forum with a particular locale language, etc. Here you have to do some customization related to setting up a default language and a language selector, for example.

Viewing, you/your visitor have to set a browser encoding to appropriate codepage format, including unicode, corresponding to codepage/charset format used in your default html encoding format/scheme established with your forum.

Or you can additionally customize your forum in various way of setting html tag, etc. Depend on what you like to do and what approach you would like to take...

Download V4b03 and allpostV4.03 patches and install V4.x and test it out. You have to collect various language packs available.

for V4.x/language packs
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=25195

for patches:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=16673

Remarks: Using unicode, you can have various language specific categories/forums in a single forum, based on V3.05. Your forum is defaulted to English_US only, and have UI messages, FAQ, pop-up etcs all in English, but can set whatever language forums. This actually works fine if you don't mind handling all Admin and other features in English user interface.









Edited by - LeoRat on 24 June 2002 17:05:20<
Go to Top of Page

n/a
deleted

593 Posts

Posted - 24 June 2002 :  22:30:51  Show Profile
Have you read install guideline for V4.x and also config.asp?
Most language packs are prepared in ISO charsets/encoding formats. Check the link I mentioned for various language packs and what formats the original authors created locale language resource files.

If you set CodePage for Lang1033 (which is a default lang) to/with UTF-8, it will reflect inc_top.asp which appear in all forums and also has a html codepage setting. Beyond that, you have to save (i.e. "prepare/package") langxxxxx.asp file with unicode charsets (save in utf-8 codepage formatted file) as ISO locale lang codepage and unicode codepage charsets are not the same - have to do some ISO to Unicode conversion. Depending on languages - like ISO Latin 1 group (which English and many European language groups belong to), probably you don't have to do but if you are handling with other groups, then, you have to ensure that all lang files are formatted in a same unicode charset...

You have English (default), German, Chinese (there are at least two major flavors of written Chinese), etc. which belong to different charsets/encoding groups.

Suggest that first you try to deploy V4.x with the current patches applied (thus V4.04 compatible) with language packs and see how your forum behave first. It's pretty stable and good, and provide you some further insights into what you can do with it and how.

Snitz seems to be quite flexible for various customization... If you want an English base forum but accommodates various language forums in it, you can take a peak at V3.05 forum in unicode, which I setup for a little testing: http://www26.brinkster.com/leorat2/forum/
(you have to set your browser encoding to Unicode(UTF-8) to view it properly).



Best
Taku










Edited by - LeoRat on 24 June 2002 22:41:02<
Go to Top of Page

Carlos Miranda Levy
Starting Member

26 Posts

Posted - 03 July 2002 :  14:29:15  Show Profile
Where is install guideline for V4.x?


--------
Con paciencia y calma, sube un burro a una palma.<
Go to Top of Page

n/a
deleted

593 Posts

Posted - 03 July 2002 :  15:40:53  Show Profile
To get V4.x (the latest V4b03.004), go to

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=25195
Find Topic Version History by Bozden
Find V4b03.004 and download links for: V4b03.003 core base international version, and, all necessary patches to make them V4b03.004 (security fixes).

Download them.
Open Config.asp, and read what needed to make your forum international/multilingual:
1. Read carefully about your DB setup
2. Read carefully how to set up additional languages besides English US (Lang1033) as a default.

3. Get all necessary language packages from the links mentioned by Bozden in his Forum. International version is designed to have a language file as a separate resource file for easier translation/localization and for better management of locale language and other specific requirements. Lang1033 is the base default language file which respective locale language authors used to localize/translate into various languages. If you are looking for a Spanish version, it should be there (which was translated/localized from Lang1033).

Hope this is helpful.

If you want to have a Dominican Spanish (I think), you can customize it to your version...as there are various falvours of Spanish exist.

Taku
i2Asia

Edited by - LeoRat on 03 July 2002 15:43:43<
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 03 July 2002 :  16:16:47  Show Profile
Thanks Leo

Think Pink
==> Start Internationalization Here<
Go to Top of Page

n/a
deleted

593 Posts

Posted - 03 July 2002 :  23:46:45  Show Profile
NP (Guess this is "No Problem")

Will be seeking your further advise also on that EC feature issue for Edit/Delete... after July4th and all.



Taku
i2Asia<
Go to Top of Page

n/a
deleted

593 Posts

Posted - 15 July 2002 :  15:58:06  Show Profile
quote:

I changed the metatag


<meta http-equiv="Content-Type" content="text/html; charset=utf-8">


and it seems now one can post/view in various languages correctly as long as the client browser is set to utf-8 also.



This is correct...basically meta setting to utf-8 for charset is primarily for html rendering of particular character sets as a default character set on web/browser....viewing them correctly on a browser...so unicode/utf-8 setting is no different from setting to BG for chinese, but saying that a default charset used will be utf-8. UTF-8 allows multiple languages displayed correctly at the same time, while other charset/codepage will individually display a selected codepage/charset properly but not all others at the same time.

quote:

the problem is: I can no longer edit my asp file
I'm working on simplified Chinese.
If I put some text in the asp file in chinese, It won't be shown, I assume I entered it in simplified chinese, but if I convert the whole asp file into utf format, the scripts are also converted.

for example. default.asp


<%some scripts%>
<tags>contents

all becomes utf, and the scripts does not work.

I can edit a file in simplified chinese or utf, but if it's a mixed one of vbscripts/jscripts and normal content, I just can't edit it.

any solutions on this?



Edited by - bjlt on 13 July 2002 10:36:46



As for codes in ASP file, it can remain in a standard ISO. If you are using locale OS enviornment, then, it will most likely prompt to a default locale codepage/charset of your system. Codepage for ASP file should/can remain in ISO charsets, only lang files can be set to UTF-8 if unicode is used. If you have Lang1033 saved/set as utf-8 file, given that it is a default language, it will set a forum default charset to utf-8. To render all other languages correctly in utf-8/unicode, you have to save your Lang2052 or other language files in utf-8, primarily for the reason of these text files/characters are "coded/defined" in utf-8 charsets. There is a html codepage setting string in inc_top.asp, so if you include the meta statement for utf-8 in inc_top, for example, you are actually duplicating the declaration. If you keep the codepage/charsets for all base ASP codes/files in ISO, you should be able to edit it in. If you have hardcoded texts strings in any of these files with Chinese, then, they won't show up correctly in Chinese, unless a base codepage is set to BG or something else. This is the same with Shift-JIS for Japanese, as far as I know. Since these scripts need to be processed/executed on a server side, I assume it won't work correctly if core codes/scripts are set to a different charset/codepage or mixed charsets but the default charset/codepage of a server enviornment.

If you are opening up files with utf-8 or in BG and editing codes and files saved in these codepage formats while a default sever is basically handling ISO-8859-1 (Latin 1) standard encoding format, then, I suspect the problem you mentioned exist....if I understand a situation correctly.

Perhaps others can clarify more on this point.

Hope this can be of some help.





Taku
<
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07