Hi my client says that the data in a particular table is in reverse order. Since it is arabic I am not able to figure out whether the data is in reverse order or whether TD SQL assisstant is displaying it reverse. If anyone has face similar issue kindly help. Below is a sample record sent by client.
Name Cat_Desc Cd Desc_AR
تاءاشنا تاءاشنا C01 تاءاشنا
It should work, according to the SA reference documentation:
Displaying Unicode® Data
To display languages such as Arabic or Hebrew, which are normally displayed from right to left, use the Regional Settings option of Windows Control Panel to install the required language support files.
The char2hexint function will return the characters in the order they occur in the string:
*** Query completed. One row found. One column returned.
For more information on writing direction see: