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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 How to select a non readable arabic word to a prop

Author  Topic 

javanees
Starting Member

3 Posts

Posted - 2014-08-25 : 08:41:52
Hi guys
I have a huge database in sql server
it has a non readable arabic letters and I want to fill another database with it
when 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 match

Where do you want the Arabic text to appear? (Not sure you can do it in SSMS.)
Go to Top of Page

javanees
Starting Member

3 Posts

Posted - 2014-08-26 : 03:07:08
I will fill with import wizard
and I will choose write a query
Go to Top of Page

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.
Go to Top of Page

javanees
Starting Member

3 Posts

Posted - 2014-08-26 : 08:47:58
I understood that is no solution for my problem :S
does SQL Server have any encoding when we select !!!???

like "select convert(columnName using utf8) as ColumnName"
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -