This is a discussion on Localization problem - RAISE EXCEPTION within the Informix forums, part of the Database Server Software category; --> Hi, I have a problem: client program doesn't see national symbols in error message from SP commands: LET msgtxt ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I have a problem: client program doesn't see national symbols in error message from SP commands: LET msgtxt = 'russian phrase'; RAISE EXCEPTION -746, 0, msgtxt; But following commands works nice: SELECT russian_text_field FROM Any_Table; UPDATE Any_Table SET russian_text_field = 'any national text'; Clients works on Windows XP SP2 with MDAC v 2.81.1117.0. Error message trouble arise when I use IBM Informix Client SDK 2.8 or 2.9, but disappears with IBM Informix Client SDK 2.5. All environment settings are permanent! Situation is identical with both our servers IDS 9.21.UC3 on Linux and Informix SE 7.25 on Windows. We use following variants of ODBC connection: 1) ConnectionString=Provider=MSDASQL.1;Password=;User ID=;Extended Properties="DRIVER={INFORMIX 3.81 32 BIT};DATABASE=morn;HOST=lin;SRVR=lin_on;SERV=sqlex ec;PRO=onsoctcp;OPT=;CLOC=ru_RU.1251;DLOC=ru_RU.57 382" 2) ConnectionString=Provider=MSDASQL.1;Persist Security Info=True;User ID=;Password=;Mode=ReadWrite;Extended Properties="DRIVER={INFORMIX 3.81 32 BIT};DATABASE=c:\infx\db\firm;HOST=ganga;SRVR=se7; SERV=sqlexec;PRO=sesoctcp;CLOC=ru_RU.1251;DLOC=ru_ RU.866;OPT=" 3) ConnectionString=DSN=morn;Password=;User ID= (DSN morn has CLIENT_LOCALR=ru_RU.1251 & DB_LOCALE=ru_RU.57382) Could anybody help me? Thanks in advance. -- Julian Zalutsky MIS cis@tut.by Computer Information Systems Ltd +375 0(162) 21-42-39 Brest, Republic of Belarus |