Topic
  • 3 replies
  • Latest Post - ‏2012-11-28T03:06:18Z by SystemAdmin
SystemAdmin
SystemAdmin
17917 Posts

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

    Re: What is SYSTEM_1252_US

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

    Re: What is SYSTEM_1252_US

    ‏2012-11-28T02:54:07Z  
    • nivanov1
    • ‏2012-11-27T14:32:17Z
    http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.admin.nls.doc/doc/r0051860.html
    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

    Re: What is SYSTEM_1252_US

    ‏2012-11-28T03:06:18Z  
    • nivanov1
    • ‏2012-11-27T14:32:17Z
    http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.admin.nls.doc/doc/r0051860.html
    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