论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2008-06-25 14:47 |只看该作者 |倒序浏览

现在有一台HP小型机，安装INFORMIX数据库。现在经常遇到特殊字符无法处理情况。比如“橫”字就无法处理。出现特殊字符的原因有多种。有些可能是由于人工操作失误，造出错误的不存在的字来。请问这样的问题可以解决么？怎么解决？谢谢！

文库|博客

liaosnet

大富大贵

论坛徽章:: 11

2楼 [报告]

发表于 2008-06-25 15:08 |只看该作者

回复 #1 lsnow8624 的帖子

hp-ux 11.11 with ibm ids 9.40fc7w4

IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line -- Up 36 days 21:53:45 -- 335252 Kbytes

Server start-up environment:

Variable          Value [values-list]
DBDELIMITER       |
DBPATH             .
DBPRINT          lp -s
DBTEMP             /tmp
INFORMIXDIR       /opt/informix
                  [/opt/informix]
                  [/usr/informix]
INFORMIXSERVER    server_online_net
INFORMIXTERM       termcap
LC_COLLATE       en_US.819
LC_CTYPE          en_US.819
LC_MONETARY       en_US.819
LC_NUMERIC       en_US.819
LC_TIME          en_US.819
LKNOTIFY          yes
LOCKDOWN          no
NODEFDAC          no
ONCONFIG          onconfig
PATH             /usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/op
                  t/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/usr/bin/X11
                  :/usr/contrib/bin/X11:/opt/pd/bin:/opt/resmon/bin:/opt/gno
                  me/bin:/opt/ignite/bin:/opt/mozilla:/opt/graphics/common/b
                  in:/usr/sbin/diag/contrib:/opt/java1.4/jre/bin:/opt/spb/bi
                  n:/opt/mx/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/informix/b
                  in:/usr/sbin:/opt/hp-gcc64/bin
SERVER_LOCALE    en_US.819
SHELL             /usr/bin/csh
TBCONFIG          onconfig
TERM             vt100
                  [vt100]
                  [dumb]
TERMCAP          /etc/termcap
TZ                EAT-8

测试一个~

Database selected.

> create table t1
> ( id char(10),
> name char(20)
> );

Table created.

> load from 22.unl insert into t1;

1 row(s) loaded.

> select * from t1;

id       name

001       张横

1 row(s) retrieved.

[ 本帖最后由 liaosnet 于 2008-6-25 15:10 编辑 ]