SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 How to select a non readable arabic word to a prop
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

javanees
Starting Member

3 Posts

Posted - 08/25/2014 :  08:41:52  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

1086 Posts

Posted - 08/25/2014 :  11:40:19  Show Profile  Reply with Quote
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 - 08/26/2014 :  03:07:08  Show Profile  Reply with Quote
I will fill with import wizard
and I will choose write a query
Go to Top of Page

gbritton
Flowing Fount of Yak Knowledge

1086 Posts

Posted - 08/26/2014 :  08:05:06  Show Profile  Reply with Quote
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 - 08/26/2014 :  08:47:58  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

1086 Posts

Posted - 08/26/2014 :  11:46:43  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000