I am working on a task migrate Sybase SQL anywhere 10.0.1 to MS SQL Server 2008
When I use upload command in SQl AnyWhere 10 to export data from table which having Unicode character set like Arabic character set '^^^Arabic^كلقفظغمشسرئب'. After exporting into text file, it was 'كلقفظغمشسرئب^Arabic^^^'. It means it is reading from right to left and writing as it is.
While importing this file to SQL server, it was writing to table as 'كلقفظغمشسرئب^Arabic^^^'.
Please help on this.
Thanks in advance
Further to Mark's comments, Arabic data is always stored in left-to-right order in memory and on disk. That's not specific to SA -- it's always done that way. It is up to the renderer/editor/etc to draw the characters right-to-left. Rendering is covered by the Unicode "BIDI" (Bidirectional) Algorithm whose gory details are here: http://www.unicode.org/reports/tr9
When you mix Arabic and non-Arabic characters in a single string, life gets more complex and, in the absence of "higher protocols", the renderer needs to decide if it is an Arabic statement containing non-Arabic letters or vice versa. A "higher protocol" could just be as simple as a default direction setting in your viewer. Without a higher protocol, different rederers may make different choices for how to render a string. See, for example, http://unicode.org/faq/bidi.html#4
answered 01 Apr '11, 14:38