Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
javanees
Starting Member
3 Posts |
 Posted - 2014-08-25 : 08:41:52
|
| Hi guysI have a huge database in sql serverit has a non readable arabic letters and I want to fill another database with itwhen I do select statement it returns something like that "ãÕÑ"how can I select this word to be a proper arabic word like "???"I'll appreciate your answer |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-25 : 11:40:19
|
| How do you plan to fill the other database?If you are doing things like:INSERT INTO otherTable (...)SELECT FROM tableWithArabic ...the data should come across just fine, assuming the types matchWhere do you want the Arabic text to appear? (Not sure you can do it in SSMS.) |
 |
|
|
javanees
Starting Member
3 Posts |
Posted - 2014-08-26 : 03:07:08
|
| I will fill with import wizardand I will choose write a query |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-26 : 08:05:06
|
| in that case, SQL will preserve the text. At that level, SQL is quite unaware what the text (i.e. NVARCHAR) columns contain. |
|
|
|
javanees
Starting Member
3 Posts |
Posted - 2014-08-26 : 08:47:58
|
| I understood that is no solution for my problem :Sdoes SQL Server have any encoding when we select !!!???like "select convert(columnName using utf8) as ColumnName" |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-26 : 11:46:43
|
| I don't think you have a problem at all. That is, SQL will preserve the data properly when you fill the other database. See this article: http://msdn.microsoft.com/en-us/library/ms143726.aspx |
|
|
|
|
|
|
How to select a non readable arabic word to a prop