Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I do not want the number in English format I need it in Arabic

I am sorry my problem I inserted number in my table in English(e.g 5),but I want to replace it in Arabic format. because I need it in Arabic to return it in text box in my windows form . hope you get what I want thanks

share|improve this question

closed as unclear what you're asking by Kin, Paul White, RolandoMySQLDBA, bluefeet, ypercube Oct 1 '13 at 15:20

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

3  
What's your question? How far have you gotten with this? Have you tried anything? –  JNK Oct 1 '13 at 12:40
3  
More to the point, I'm pretty sure the database stores the numbers as binary data, not as a string. The way the numbers output is probably dependent on your localization settings. –  JNK Oct 1 '13 at 12:48
    
Next time, please log in before editing the question. –  Jon Seigel Oct 1 '13 at 17:28

1 Answer 1

My guess is you are doing this:

INSERT dbo.MyTable(MyColumn) VALUES('أَبْجَدِي');

Then when you select, you are getting:

?????????

In order to maintain the original string, you need to denote that the value is Unicode by using the N prefix. So:

INSERT dbo.MyTable(MyColumn) VALUES(N'أَبْجَدِي');
------------------------------------^

You can reproduce this quite easily:

SELECT 'أَبْجَدِي', N'أَبْجَدِي';

Results:

---------    ---------
?????????    أَبْجَدِي
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.