Samuel
-
Total Posts
:
11785
-
Reward points
:
168350
- Joined: May 23 '01
|
Double-byte character installation note
-
Mon. Jan 13, '03 2:39 AM
This info applies to the non-unicode version of the software only. Users with the unicode version do not have to worry about anything outlined below If you are using a double-byte character version of Windows (Traditional Chinese, Thai, Japanese, etc.), please follow the steps below. The installation procedure is slightly different from that with single-byte character Windows. I will use Thai language as an example: - create a database with THAI_CI_AS_KS_WS collation (since it is Thai version of Windows).
- execute the full installation sql script we supplied against your newly created database
- Add a codepage directive in masterinclude.asp, so the whole line reads
<%@Language="VBScript" LCID="1033" Codepage="874" %>
874 is the codepage for Thai language. For complete information on codepages and character-sets, please refer to this web page - finish the installation by following the readme.htm file in the package, and then log in as admin
- Go to " basic configuration" , and change the forum character-set to " windows-874" (without quote). Windows-874 is the specific character-set for the Thai language. Please refer to this web page for languages and their corresponding character-sets.
That' s it. The most important thing here is the codepage directive in masterinclude.asp.
For ASP.NET version users
You basically do the same thing described above, but the code page setting has to be changed in the globalization section in web.config, not in masterinclude.aspx.
<message edited by Samuel on Fri. Jul 4, '08 12:05 AM>
ASPPlayground.NET ~ see our Version 4 plans here
|
|
Samuel
-
Total Posts
:
11785
-
Reward points
:
168350
- Joined: May 23 '01
|
Locale, Collation, and Codepage
-
Sun. Mar 7, '04 1:59 AM
The following are taken directly from SQL books online.
| Windows locale |
Collation designator |
Code page |
| Afrikaans |
Latin1_General |
1252 |
| Albanian |
Albanian |
1250 |
| Arabic (Saudi Arabia) |
Arabic |
1256 |
| Arabic (Iraq) |
Arabic |
1256 |
| Arabic (Egypt) |
Arabic |
1256 |
| Arabic (Libya) |
Arabic |
1256 |
| Arabic (Algeria) |
Arabic |
1256 |
| Arabic (Morocco) |
Arabic |
1256 |
| Arabic (Tunisia) |
Arabic |
1256 |
| Arabic (Oman) |
Arabic |
1256 |
| Arabic (Yemen) |
Arabic |
1256 |
| Arabic (Syria) |
Arabic |
1256 |
| Arabic (Jordan) |
Arabic |
1256 |
| Arabic (Lebanon) |
Arabic |
1256 |
| Arabic (Kuwait) |
Arabic |
1256 |
| Arabic (United Arab Emirates) |
Arabic |
1256 |
| Arabic (Bahrain) |
Arabic |
1256 |
| Arabic (Qatar) |
Arabic |
1256 |
| Basque |
Latin1_General |
1252 |
| Byelorussian |
Cyrillic_General |
1251 |
| Bulgarian |
Cyrillic_General |
1251 |
| Catalan |
Latin1_General |
1252 |
| Chinese (Taiwan) |
Chinese_Taiwan_Bopomofo |
950 |
| Chinese (Taiwan) |
Chinese_Taiwan_Stroke |
950 |
| Chinese (People's Republic of China) |
Chinese_PRC |
936 |
| Chinese (People's Republic of China) |
Chinese_PRC_Stroke |
936 |
| Chinese (Singapore) |
Chinese_PRC |
936 |
| Croatia |
Croatian |
1250 |
| Czech |
Czech |
1250 |
| Danish |
Danish_Norwegian |
1252 |
| Dutch (Standard) |
Latin1_General |
1252 |
| Dutch (Belgium) |
Latin1_General |
1252 |
| English (United States) |
Latin1_General |
1252 |
| English (Britain) |
Latin1_General |
1252 |
| English (Canada) |
Latin1_General |
1252 |
| English (New Zealand) |
Latin1_General |
1252 |
| English (Australia) |
Latin1_General |
1252 |
| English (Ireland) |
Latin1_General |
1252 |
| English (South Africa) |
Latin1_General |
1252 |
| English (Carribean) |
Latin1_General |
1252 |
| English (Jamaican) |
Latin1_General |
1252 |
| Estonian |
Estonian |
1257 |
| Faeroese |
Latin1_General |
1252 |
| Farsi |
Arabic |
1256 |
| Finnish |
Finnish_Swedish |
1252 |
| French (Standard) |
French |
1252 |
| French (Belgium) |
French |
1252 |
| French (Switzerland) |
French |
1252 |
| French (Canada) |
French |
1252 |
| French (Luxembourg) |
French |
1252 |
| Georgian (Modern Sort) |
Georgian_Modern_Sort |
1252 |
| German (PhoneBook Sort) |
German_PhoneBook |
1252 |
| German (Standard) |
Latin1_General |
1252 |
| German (Switzerland) |
Latin1_General |
1252 |
| German (Austria) |
Latin1_General |
1252 |
| German (Luxembourg) |
Latin1_General |
1252 |
| German (Liechtenstein) |
Latin1_General |
1252 |
| Greek |
Greek |
1253 |
| Hebrew |
Hebrew |
1255 |
| Hindi |
Hindi |
Unicode only |
| Hungarian |
Hungarian |
1250 |
| Hungarian |
Hungarian_Technical |
1250 |
| Icelandic |
Icelandic |
1252 |
| Indonesian |
Latin1_General |
1252 |
| Italian |
Latin1_General |
1252 |
| Italian (Switzerland) |
Latin1_General |
1252 |
| Japanese |
Japanese |
932 |
| Japanese (Unicode) |
Japanese_Unicode |
932 |
| Korean (Extended Wansung) |
Korean_Wansung |
949 |
| Korean |
Korean_Wansung_Unicode |
949 |
| Latvian |
Latvian |
1257 |
| Lithuanian |
Lithuanian |
1257 |
| Lithuanian |
Lithuanian_Classic |
1257 |
| Macedonian |
Cyrillic_General |
1251 |
| Norwegian (Bokmål) |
Danish_Norwegian |
1252 |
| Norwegian (Nynorsk) |
Danish_Norwegian |
1252 |
| Polish |
Polish |
1250 |
| Portuguese (Standard) |
Latin1_General |
1252 |
| Portuguese (Brazil) |
Latin1_General |
1252 |
| Romanian |
Romanian |
1250 |
| Russian |
Cyrillic_General |
1251 |
| Serbian (Latin) |
Cyrillic_General |
1251 |
| Serbian (Cyrillic) |
Cyrillic_General |
1251 |
| Slovak |
Slovak |
1250 |
| Slovenian |
Slovenian |
1250 |
| Spanish (Mexico) |
Traditional_Spanish |
1252 |
| Spanish (Traditional Sort) |
Traditional_Spanish |
1252 |
| Spanish (Modern Sort) |
Modern_Spanish |
1252 |
| Spanish (Guatemala) |
Modern_Spanish |
1252 |
| Spanish (Costa Rica) |
Modern_Spanish |
1252 |
| Spanish (Panama) |
Modern_Spanish |
1252 |
| Spanish (Dominican Republic) |
Modern_Spanish |
1252 |
| Spanish (Venezuela) |
Modern_Spanish |
1252 |
| Spanish (Colombia) |
Modern_Spanish |
1252 |
| Spanish (Peru) |
Modern_Spanish |
1252 |
| Spanish (Argentina) |
Modern_Spanish |
1252 |
| Spanish (Ecuador) |
Modern_Spanish |
1252 |
| Spanish (Chile) |
Modern_Spanish |
1252 |
| Spanish (Uruguay) |
Modern_Spanish |
1252 |
| Spanish (Paraguay) |
Modern_Spanish |
1252 |
| Spanish (Bolivia) |
Modern_Spanish |
1252 |
| Swedish |
Finnish_Swedish |
1252 |
| Thai |
Thai |
874 |
| Turkish |
Turkish |
1254 |
| Ukrainian |
Ukrainian |
1251 |
| Urdu |
Arabic |
1256 |
| Vietnamese |
Vietnamese |
1258 |
ASPPlayground.NET ~ see our Version 4 plans here
|
|