Installing Sybase on Your Linux Server - page 4
Why Look at Sybase?
All of the necessary files and advice about Russian language localization can be found at http://www.sybase.newmail.ru/ase/119rus.html. To find your own language localization guides, use any search engine you like and you should be able to find your language packs without much difficulty.
Before we begin this process, make sure you pay attention to upper/lower case in file names. Linux, as with all Unix systems, understands upper and lowers case as different characters, and this can create some problems if you're not careful.
I was also able to find an absolutely prepared Russian localization package for Linux following this link: ftp://ftp.svzserv.kemerovo.su/pub/databases/sybase-ase/Synchsets.tgz. I recommend everybody who needs Russian localization. If you also download http://www.sybase.newmail.ru/files/convtbls.zip you can find a good description of installation inside that package.,
In the meantime, to illustrate how localization works in whatever language you use, I will describe whole process step by step.
First, unpack and copy the appropriate files.
tar -xzf Synchsets.tgz cp -r charsets/group5/* $SYBASE/charsets cp -r convtbls/group5/* $SYBASE/charsets cp -r locales/group5/* $SYBASE/locales
Remember, don't copy the locales.dat file from the archive! It's very old.
Fix files common.loc and server.loc in all subdirectories $SYBASE/locales/russian/--if you have an earlier version, you will need to change the version of these files to that of your server.
Unpack the convtbls.zip archive and copy all tables of conversions utf8->russian:
unzip convtbl.zip cp CONVTBLS/UNICODE/UTF8/CP866.CTB $SYBASE/charsets/utf8/cp866.ctb cp CONVTBLS/UNICODE/UTF8/KOI8.CTB $SYBASE/charsets/utf8/koi8.ctb cp CONVTBLS/UNICODE/UTF8/CP1251.CTB $SYBASE/charsets/utf8/cp1251.ctb
Update the configuration file $SYBASE/charsets/utf8/utf8.cfg by adding these lines:
convertto = koi8, table, MATCH, 3F convertto = cp1251, table, MATCH, 3F convertto = cp866, table, MATCH, 3F
And update the file with locales descriptions $SYBASE/locales/locales.dat by adding into the [linux] section these lines:
locale = ru_RU, russian, koi8 locale = ru_UA, russian, koi8
This will allow out Linux clients to operate more smoothly with the new language. Now, into the [natlang] section in the file $SYBASE/config/objectid.dat add:
; russian 22.214.171.124.4.1.8126.96.36.199.182119 = russian
Now, don't forget to do little cleanup:
ln -s $SYBASE/locales/message/us_english $SYBASE/locales/messages/russian ln -s $SYBASE/locales/us_english/cp850 $SYBASE/locales/us_english/cp866 ln -s $SYBASE/locales/us_english/cp850 $SYBASE/locales/us_english/cp1251 ln -s $SYBASE/locales/us_english/cp850 $SYBASE/locales/us_english/koi8
The next major step to to load a new list of chars and their sort order. The easiest way is to use graphic utility that came with Sybase:
su sybase $ cd ~ $ bin/sqlloc
In the first window (shown in Figure 4), you have to choose your server.
We do not have password for sa by default. So, just click on OK to open the Default Language dialog box (see Figure 5).
And now let's configure the necessary localization. For example, to support the Windows codepage, with sorting, without dependence of lower/upper case we will choose these options in each respecitive field in the dialog: Russian, cp1251, Russian case-insensitive dictionary ordering.
After clicking on OK, the Add and Remove Languages dialog will appear to will warn us that the codepage will be changed and it will suggest installing a new language (Russian). Again, click on OK. The Localization Summary dialog will appear (see Figure 6).
The utility will start installing support for the Russian language, shown in the Status Output window. Eventually the Status Report window will close and you will be returned to the User Name and Password dialog. Choose Exit.
When configuring the client (OpenClient) for Windows we need to remember to update $SYBASE/ini/objectid.dat. In the section [natlang] add:
; russian 188.8.131.52.4.1.8184.108.40.206.182119 = russian
Also, add identifers of Russian codepages (if you don't have such) in section [charset]:
220.127.116.11.4.1.818.104.22.168.50 = iso88595 22.214.171.124.4.1.8126.96.36.199.51 = cp855 188.8.131.52.4.1.8184.108.40.206.52 = cp866 220.127.116.11.4.1.818.104.22.168.53 = cp1251 22.214.171.124.4.1.8126.96.36.199.55 = koi8 188.8.131.52.4.1.8184.108.40.206.56 = mac_cyr
Solid state disks (SSDs) made a splash in consumer technology, and now the technology has its eyes on the enterprise storage market. Download this eBook to see what SSDs can do for your infrastructure and review the pros and cons of this potentially game-changing storage technology.
- 1Linux Top 3: CoreOS, Oracle Enterprise Linux 7 and Ubuntu 14.10
- 2Linux Top 3: Debian Dumps SPARC, Ubuntu Takes Over Linux 3.13 and the Core Infrastructure Initiative
- 3Linux Top 3: Fedora, Ubuntu and Gluster Lose Community Leaders
- 4Red Hat Enterprise Linux 7 Finally Hits the Big Time
- 5Linux Top 3: Tails 1.0, OpenMandriva Lx 2014.0 and Debian 7.5