HELP! DB2 return corrupted data in Chinese win95

[Lewis Leung]

When I use IBM ODBC (v5.2) with chinese win95 to connect DB2 in Unix server,
any string returned with char datatype is corrupted (first 2 characters are
removed). However, string with varchar type is not affected. Also there is
no problem in English win95.

Is it a DBCS problem ?

Thanks

[Ez Paling1]

Sorry to bother you! If you or anyone you know is
interested, please let me know!

DB2 DBA’s CENTRAL JERSEY
(Multiple positons available)

Major financial services firm seeks multiple DB2
DBA’s. There are several different projects running
simultaneously. Some of the work to be done includes:
- Production support
- Infrastructure work
- Documentation
- New Development
- Maintenance
- Disk Management
- Performance Management
- Documenting Existing System

5+ years of DB2 DBA experience.
Full Time positions only, must be US citizen or
authorized to work Fulltime.
Salary u pto $120,000

!!IMMEDIATE INTERVIEW FOR QUALIFIED CANDIDATES
GUARANTEED!!

For more specific information regarding client and
project, contact:
Colton Information Technology
63 Wall Street - Suite 2901
New York, NY 10005
Contact: Esmeldin (EZ) Paling
Voice: (212) 248-9700 Ext. 202
Fax: (212) 509-1633
Ezpa...@aol.com
WWW.tcg1.com

[Paul Watson]

Are the first two characters (which are removed) DBCS two-byte characters?

Is this Big5 or GB?

Which UNIX server? AIX, Solaris, Linux?

What is the territory, code page, code set, and country code of the
database?
GET DB CFG FOR database-alias

Lewis Leung <le...@hknet.com> wrote in message
news:37023...@ruby.hknet.com...

[Lewis]

All database data are string only (i.e. no DBCS characters). UNIX server is
AIX.
I have issued GET DB command and the following information are shown.

Database territory = en_US
Database code page = 819
Database code set = ISO8859-1
Database country code = 1

Does database configuration not match chinese win95 system ? If so, how can
I change these configurations.

Thanks.

Paul Watson ????? ...

[Paul Watson]

Chinese Win9x machine codepage is perhaps 936 or 950 depending on whether
you have Simplified (China) or Traditional (Taiwan).version.

http://www.microsoft.com/GlobalDev/Reference/wincp.htm

Use the following SQL to find out the codepage of each database column. This
is modified from page 285 of the DB2 UDB Certification Guide book in the
listcols.dml file.

select colname,typename,length,codepage from syscat.columns where tabname =
'<TABLENAME>';