INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Arabic language in my sql show as ?????? why and how to solve

Arabic language in my sql show as ?????? why and how to solve

RE: Arabic language in my sql show as ?????? why and how to solve

it all comes down to

1. method of upload of the information
2. the charset of the database table
3. the charset of the connection between the client and the database server.
4. the charset of the page on which you are displaying the data

they must all be capable of handling the charset you want and must all be talking the same charset when they get/push data.

RE: Arabic language in my sql show as ?????? why and how to solve

If the other menu entries are populated from the database, then I would think jpadie's 1st suggested issue would be most relevant.

Were the entries higher in the UL list entered in the same way that the ????? entry was added?

RE: Arabic language in my sql show as ?????? why and how to solve

(OP)
Thank you for reply
In this website there are strange thing or missing point
Database is :
http://files.engineering.com/getfile.aspx?folder=d...
see no 15,16
different in language
Interface PHP
See Difference
http://files.engineering.com/getfile.aspx?folder=9...
same interface code
but different only in language
How to change ???? to الصيانه
i set collision for table is
utf8_general_ci
i set collision for database
utf8_general_ci
for colmun used for arabic is
utf8_general_ci

RE: Arabic language in my sql show as ?????? why and how to solve

read my post.

you need to make sure that:

1. the form that you upload data from is from a utf8 charset (if you don't, and the charset used is less rich, you will lose information)
2. the table uses ut8 charset (not just collation) (ditto above)
3. the CONNECTION to the database server uses utf8 (ditto above, there will be an implicit conversion)
4. the pages displaying the data uses utf8 (ditto ish. there will be an implicit conversion but this will not be permanent as the data storage is not touched)

RE: Arabic language in my sql show as ?????? why and how to solve

(OP)
Thank you for reply
if problem in interface(php) Unicode or connection there are more text shown in same page in website
but correctly show Arabic language why this only not show
the menu and sub menu from Database shown
And how to set charset to utf8

RE: Arabic language in my sql show as ?????? why and how to solve

(OP)
I check my web page php i found charset found as following
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
meaning have charset
How to make charset for table

RE: Arabic language in my sql show as ?????? why and how to solve

every part needs to be utf8. the page, the form, the database table, the database connection etc.

if you are convinced that this is the case, then those fields that are not displaying correctly were inputted using a different mechanism.

for mysql in php you make sure that the connetion is in utf8 like this

CODE

mysql_connect($host, $user, $pass);
mysql_query('SET NAMES "utf8"');
mysql_select_db($db); 

RE: Arabic language in my sql show as ?????? why and how to solve

(OP)
Thank you for reply
you are true
i changed the code in query above using utf8 as you tell me in previous thread
then go to MySQL and remove strange character then rewrite using Arabic language
and OK working but this is will take too much time to change all and rewrite
Are there are any way to accept strange characters(اتصل بنا) and in same time
accept any new characters Arabic
Example
Before changes (Before add MySQL_query in connection in php) as link below
www.altawi.com.sa
Database
Arabic field :اتصل بنا(WRONG FORMAT) remove that and write كيف حالك
PHP WEBSITE IT SHOW AS FOLLOWING
???????(misunderstood FORMAT)
After changes(after add mysql_query in connection in php) as link below
Database
Arabic field :اتصل بنا(WRONG FORMAT) remove that and write كيف حالك
PHP WEBSITE IT SHOW AS FOLLWOING
كيف حالك (CORRECT FORMAT)
this is OK after changed and i accepted
Only problem Now to make this will take too much time may be one 15 days
Are there are any modification to change that and in same time accept new charachter

RE: Arabic language in my sql show as ?????? why and how to solve

(OP)
This will take too much time because every misunderstood format in MySQL
must removed and changed to correct format Arabic to all Arabic text in website
so that if there are any way to accept this strange character then show as website
as www.altawi.com.sa

RE: Arabic language in my sql show as ?????? why and how to solve

unless you know what character set was used to store and transmit the 'bad' information we cannot advise with any accuracy.

However the likelihood is that you have lost data density in the transliteration from one character set to another. If this is the case then you will not be able to get it back. If both charsets used were 8bit AND no transliteration has occurred then it is possible that you can decode and re-encode without data loss. For example ISO 8859-6 is 8 bit, as is utf8.



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close