on 2011 Apr 01 7:41 AM
Hello,
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
NL
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry it is unload command, not upload.
I am new to Sybase. Here my task is migrate the Sybase DB to MS SQL Server. One of the tables contains the candidate name field which is mix of English and Arabic Characters like ‘^^^Arabic^كلقفظغمشسرئب'.
I use Unload command to export the table content to csv file, Arabic text comes first, but character are still in the same order, os it is 'كلقفظغمشسرئب^Arabic^^^'. And after importing the csv file into SQL server, the order was retained (i.e. ‘ 'كلقفظغمشسرئب^Arabic^^^'’)
I need to migrate that name field '^^^Arabic^كلقفظغمشسرئب' as it is into SQL server from Sybase 10.
Please help on this.
Thanks, NL
I still suggest that it very likely to be precisely the same data in both places but you are using two different viewers (GUIs, editors, etc) that have different rules on how to display the mixed Arabic and English. There is absolutely no way that SA will reorder the bytes of the string and it is highly unlikely that any software would do that. Only software that displays bidirectional text makes those choices.
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.