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 220.127.116.11.4.1.818.104.22.168.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 22.214.171.124.4.1.8126.96.36.199.182119 = russian
Also, add identifers of Russian codepages (if you don't have such) in section [charset]:
188.8.131.52.4.1.8184.108.40.206.50 = iso88595 220.127.116.11.4.1.818.104.22.168.51 = cp855 22.214.171.124.4.1.8126.96.36.199.52 = cp866 188.8.131.52.4.1.8184.108.40.206.53 = cp1251 220.127.116.11.4.1.818.104.22.168.55 = koi8 22.214.171.124.4.1.8126.96.36.199.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: GNOME 3.12 and New Betas for Ubuntu 14.04 and OpenMandriva Lx 2014.0
- 2Linux Top 3: Linus Lashes out, Linux 3.14 Gets PIE and Ubuntu One is Done.
- 3Linux Top 3: Ubuntu 14.04, Debian Gives Squeeze More Life and Red Hat Goes Atomic
- 4Linux Top 3: CoreOS, Oracle Enterprise Linux 7 and Ubuntu 14.10
- 5Linux Top 3: Debian Gives Up on Upstart, Ubuntu and Linux Kernel Updates