Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
3 replies Latest Post - ‏2012-11-28T03:06:18Z by SystemAdmin
SystemAdmin
SystemAdmin
17917 Posts
ACCEPTED ANSWER

Pinned topic What is SYSTEM_1252_US

‏2012-11-27T07:56:12Z |
Dears,

I ran the following SQL and got the SYSTEM_1252_US for collate_info. Does anyone know what is SYSTEM_1252_US? I could not google it. With this sequences, the 'a' actually is less than 'A'. Is there any resource/link for this encoding?

SELECT NAME, VALUE
FROM SYSIBMADM.DBCFG
where NAME in ('codepage','codeset','collate_info')

codepage 1208
codeset UTF-8
collate_info SYSTEM_1252_US

Thanks,
RR
Updated on 2012-11-28T03:06:18Z at 2012-11-28T03:06:18Z by SystemAdmin
  • nivanov1
    nivanov1
    231 Posts
    ACCEPTED ANSWER

    Re: What is SYSTEM_1252_US

    ‏2012-11-27T14:32:17Z  in response to SystemAdmin
    http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.admin.nls.doc/doc/r0051860.html
    • SystemAdmin
      SystemAdmin
      17917 Posts
      ACCEPTED ANSWER

      Re: What is SYSTEM_1252_US

      ‏2012-11-28T02:54:07Z  in response to nivanov1
      Thanks.
      Please forgive my ignorant.
      With the above setting, I still could not explain the results from following sql(why 'A' is greater than 'a' according to SYSTEM_1252_US):

      SELECT * FROM RKYTEST ORDER BY col desc
      A
      a
      2
      1
    • SystemAdmin
      SystemAdmin
      17917 Posts
      ACCEPTED ANSWER

      Re: What is SYSTEM_1252_US

      ‏2012-11-28T03:06:18Z  in response to nivanov1
      Oh.....I see....

      The table of the codepage1252(SYSTEM_1252) shows the ascending order of those characters. And 'a' is before 'A'('a'<').

      X'61' X'0061' X'61'
      X'41' X'0041' X'41'

      Thanks,
      RR