Re: diacriticals

On Wed, 12 Aug 1998, Nick Nobbe wrote: > environment: > Online 7.13+ > Wyse 50 terminal emulation > > Using dbaccess, I can't seem to set a varchar field to characters with > diacriticals, like =E9 for example. The vi editor displays the characters in > escaped octal (looks like). I suspect that means that DB-Access is setting your terminal to display 7-bit characters only. However, it is hard to prove this -- you probably need to run the DB-Access program in a window with a known tty device name (/dev/pts/9 for sake of discussion), and then, in some other window, analyze the tty settings on the DB-Access window with the command: stty -a < /dev/pts/9 If you're using an older BSD-based machine, you may have to redirect stdout instead of stdin to /dev/pts/9, and the answer will presumably appear on stderr. I ran into problems on Solaris 2.5.1 where it would not show the diacriticals as anything other than the escaped octal characters. > What's interesting - I can create a text file with the diacriticals using a > Windows editor and then load the text file into a temp table, and then > update the actual field in an existing table from the temp table. It looks > like the editors and interfaces (like dbaccess) are getting in the way. The > database will store (and display) the diacritical characters. > > Has anyone else dealt with this problem and found it solvable or unsolvable? > > We are developing a front end with Power Builder and would like to pass PB > the characters in question as part of an update statement. You can definitely do that if the characters are part of the value of a host variable. You may not get away with it if you use statements with the diacriticals in the statement text. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.59 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn