Kbase P115426: How to enter Cyrillic Russian characters in Progress?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/09/2008 |
|
Status: Unverified
GOAL:
How to enter Cyrillic Russian characters?
GOAL:
What is required to store Russian data into a database?
GOAL:
How can GUI and Character clients be used to store Russian Cyrillic data into the same database?
FACT(s) (Environment):
UNIX
Windows
Progress 9.x
OpenEdge 10.x
FIX:
The Database:
The database must use a Cyrillic code page or UTF-8. On Windows the database should use the code page 1251, ibm866 or UTF-8. On UNIX the database should use the iso8859-5 code page. Any database broker should (usually) be started using the same code page setting as the database for cpinternal and cpstream. It should also (usually) use the same collation as the database. For example, to start a broker on Windows:
proserve Cyrillic2000 -H <host> -S <service> -N TCP -cpinternal 1251 -cpstream 1251 -cpcoll russian
Windows Clients.
Windows clients should have their locale set to Russian via:
Start->Settings->Control Panel->Regional and Language Options->Advanced TAB.
After a reboot this should set the default Windows code page to 1251 and the default OEM DOS code page to 866. You can confirm this by running:
Start->Run->cmd and then typing "chcp". The default active code page should then be 866. If the default active code page is 866 then a Character client session can be started as follows:
_progres.exe -db Cyrillic2000 -H <host> -S <service> -N TCP -cpinternal ibm866 -cpstream ibm866 -cpcoll russian
To start a GUI client to connect to the same Cyrillic database you can then use the following startup parameters:
prowin32.exe -db Cyrillic2000 -H <host> -S <service> -N TCP -cpinternal 1251 -cpstream 1251 -cpcoll russian
In OpenEdge 10 the GUI unicode client can also be used to connect to the cyrillic database with:
prowin32.exe -db Cyrillic2000 -H <host> -S <service> -N TCP -cpinternal UTF-8 -cpstream UTF-8 -cpcoll ICU-ru
UNIX Clients.
On UNIX the character client sessions should be started with the following parameters:
mpro -db Cyrillic2000 -H <host> -S <service> -N TCP -cpinternal iso8859-5 -cpstream iso8859-5 -cpcoll russian