Teradata SQL Assistant displays Arabic in reverse order

Database
Enthusiast

Teradata SQL Assistant displays Arabic in reverse order

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                            تاءاشنا

1 REPLY
Teradata Employee

Re: Teradata SQL Assistant displays Arabic in reverse order

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:

 sel char2hexint('تاءاشنا');

 *** Query completed. One row found. One column returned.

Char2HexInt('تاءاشنا')

----------------------------

062A062706210627063406460627

For more information on writing direction see:

http://www.unicode.org/faq/bidi.html#3