inserting arabic characters into mysql

Reply

Join Date: Sep 2007
Posts: 25
Reputation: roy-- is an unknown quantity at this point 
Solved Threads: 0
roy-- roy-- is offline Offline
Light Poster

inserting arabic characters into mysql

 
0
  #1
Oct 17th, 2007
Hello,

I have looked everywhere on the web for a solution to this problem.

I am trying to store arabic characters into mysql via an html form.

i have set the meta charset to utf-8 and have tried mysql_query('set names 'utf=8'")

but still i get garbled characters in my table:

لربيلبي

Please advise!
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 271
Reputation: fatihpiristine has a little shameless behaviour in the past 
Solved Threads: 16
fatihpiristine's Avatar
fatihpiristine fatihpiristine is offline Offline
Posting Whiz in Training

Re: inserting arabic characters into mysql

 
0
  #2
Oct 17th, 2007
Do a favour, leave me alone
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 25
Reputation: roy-- is an unknown quantity at this point 
Solved Threads: 0
roy-- roy-- is offline Offline
Light Poster

Re: inserting arabic characters into mysql

 
0
  #3
Oct 18th, 2007
thanks faith but that didnt help with my problem.

:/
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 271
Reputation: fatihpiristine has a little shameless behaviour in the past 
Solved Threads: 16
fatihpiristine's Avatar
fatihpiristine fatihpiristine is offline Offline
Posting Whiz in Training

Re: inserting arabic characters into mysql

 
0
  #4
Oct 18th, 2007
did you try ansi_unicode_?
Do a favour, leave me alone
Reply With Quote Quick reply to this message  
Join Date: Dec 2006
Posts: 160
Reputation: w_3rabi is an unknown quantity at this point 
Solved Threads: 9
w_3rabi's Avatar
w_3rabi w_3rabi is offline Offline
Junior Poster

Re: inserting arabic characters into mysql

 
0
  #5
Oct 20th, 2007
i have something like this
i insert data into db
in the db the data is not readable
but when select it on a php page
everything goes well
so the application is running anyway
programming is an art ,only for those who can understand it.
- th3 php wr3nch -
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 271
Reputation: fatihpiristine has a little shameless behaviour in the past 
Solved Threads: 16
fatihpiristine's Avatar
fatihpiristine fatihpiristine is offline Offline
Posting Whiz in Training

Re: inserting arabic characters into mysql

 
0
  #6
Oct 20th, 2007
is it local or remote located database?
if locale chech my.ini, find default charset and change it to ansi_unicode
collation in the same way.
Do a favour, leave me alone
Reply With Quote Quick reply to this message  
Join Date: Sep 2007
Posts: 25
Reputation: roy-- is an unknown quantity at this point 
Solved Threads: 0
roy-- roy-- is offline Offline
Light Poster

Re: inserting arabic characters into mysql

 
0
  #7
Oct 21st, 2007
Got it working!

mysql_query("set names 'utf8'");

Thanks everyone for your replies..
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC