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
where NAME in ('codepage','codeset','collate_info')
This topic has been locked.
3 replies Latest Post - 2012-11-28T03:06:18Z by SystemAdmin
Pinned topic What is SYSTEM_1252_US
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-28T03:06:18Z at 2012-11-28T03:06:18Z by SystemAdmin
nivanov1 100000H9H7231 Posts
Re: What is SYSTEM_1252_US2012-11-28T02:54:07Z in response to nivanov1Thanks.
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