A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
this week in the
Other Open Source APIs
JDBC and Relational Databases
DB2 Encoding Scheme
Joined: Apr 12, 2001
Jun 27, 2007 21:14:00
Not sure if this Q belongs to this forum:
To find the encoding of a particular table or schema in DB2 the following queries help:
SELECT ENCODING_SCHEME FROM SYSIBM.SYSTABLES WHERE NAME = 'mytable' or SELECT distinct encoding_scheme FROM SYSIBM.SYSTABLES WHERE creator='GIBFCIA'
But how to find the version of the encoding, i.e., if it is UTF-8 or UTF-16?
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.<br />- Dr. Seuss
It is sorta covered in the
JavaRanch Style Guide
subject: DB2 Encoding Scheme
arabic data from the database
Date manipulation .......
how can i choose the right encoding to read arabic
LockMode.UPGRADE produces false sql ?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015