Unable to sort the BDC column which contain space

Let me explain you with an example, If you have table like described below and you would like to show the “Name” field as “First Name”. 

Table Name :- employee_test

Table description
ID NUMBER
NAME VARCHAR2(20)
LOCATION VARCAHR2(20)
AGE NUMBER

Create the view using the following SQL command

Create view view_employee as SELECT ID, NAME AS "FIRST NAME", LOCATION, AGE FROM EMPLOYEE_Test

Generally  you create a application definition file view_employee.xml and add the Type descriptor like this ;-

<TypeDescriptor TypeName="System.String" Name="FIRST NAME" />

and now if you try to sort the Business Data List web part , you won’t get the correct result. To resolve this use the following SQL command :-

create view view_employee as SELECT ID, NAME , LOCATION, AGE FROM EMPLOYEE_Test

Change the type descriptor for your localized version (In my example I changed for English-Us so the LCID is 1033) in the application definition file. I fetched the Name without using the space but changed it for the display purposes.

<TypeDescriptor TypeName="System.String" Name="NAME">
<LocalizedDisplayNames>
<LocalizedDisplayName LCID="1033">FIRST NAME </LocalizedDisplayName>
</LocalizedDisplayNames>
</TypeDescriptor>