473,688 Members | 3,192 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Language / Character set with phpmyadmin

Dear all,
Hello to all the great minds of php. My humble question is regarding
the phpmyadmin. As you know the welcome screen of phpmyadmin allows
one to choose the language.
My question is this: if the data was entered into a database of mySQL
in UNICODE, like "محمدان" and so
fort, then how can we display this in a readable format when for
example trying to Insert a new record from the phpmyadmin Insert
option for the particular table? Because all I get is the unicode text
back when I press the Insert or Browse records links.
So here is what happened: mySQL database and tables were created using
command line. Relationships were then added using phpmyadmin. Records
were then inserted into the tables typing the Arabic into the
availabel table fields. Now, the records are ofcourse kept in the
mySQL database as unicode like I mentioned above, but when I press the
Insert button, I want to see the human readable text and
relationships, not the unicode text directly from database.
Not that I already know how to display these records in a php page off
the database, but how can I do this from phpmyadmin? My efforts to
change the language settings to any Arabic or similar character sets
failed and the same unicode text like mentioned above is displayed,
please help or I will have to write a lot of unnecessary code to
create separate admin.
Thanks,
ghasem
Jul 17 '05 #1
0 2035

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1754
by: lawrence | last post by:
If I have, say, a windows-1280 character in some text because someone, somewhere, copy and pasted something from Microsoft Word to my online CMS, but I've declared an encoding of, say, UTF-8, is there a way to clean that up using PHP? I already run the text through htmlspecialchars and htmlentities but that is not enough. I'm drawing an error because of something on my weblog that I copied and pasted from elsewhere. This validator flags...
7
6446
by: SCS | last post by:
Running PHP 4.5.7 PHPMyAdmin 2.5.7-pl1 IIS 6 I am thrying to get phpmyadmin to work, but whenever I click a link or try to browse a database I get a 404 error, because the PmaAbsoluteUri auto-detection is nor working properly. Im pretty sure it is a problem with my php.ini file, but Im not sure where to look... can someone please help
0
3472
by: NewbieSupreme | last post by:
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x, which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a table to a text file, tab-delimited, text qualifyer of "none" (this is how I read to do it from newsgroups). When I use the Query window in phpmyadmin to import the text file, it waits a while, then returns an error: #1064 - You have an error in your SQL syntax; check the manual that...
1
1512
by: Marcus | last post by:
Hello, I recently upgraded from 4.0 to 4.1. I've spent the last few days reading up on charsets since I never really thought about it when I used 4.0. I thought I had most of it figured out, but then I saw this in phpMyAdmin and am as confused as when I started: MySQL charset: UTF-8 Unicode (utf8) MySQL connection collation: utf8-unicode-ci (in a dropdown box)
5
3045
by: Marcus | last post by:
Hello, I am having a problem with a query in phpMyAdmin... it works fine on my localhost, but the exact same query produces an error in phpMyAdmin on my server: localhost: PHP 4.3.11, MySQL 4.1.12, phpMyAdmin 2.8.1 server: PHP 4.3.11, MySQL 4.1.12, phpMyAdmin 2.6.3-pl1 SELECT AES_DECRYPT(pass, 'asdf') FROM `test`
2
6801
by: Victor | last post by:
Could anybody kindly point me to a clue in the following enigma : I have phpMyAdmin - 2.8.2.4 and MySQL - 4.1.13-nt. In the phpMyAdmin opened in any browser I am able to enter and store Russian characters in the DB; I cal also call the data back to display them in the phpMyAdmin. When I try to do the same from my own page, only some garbage with double as many characters as an original word gets stored in the DB (at least I see it...
10
12756
by: farukcse | last post by:
Dear Sir, i am facing a encoding problem with MySQL data base and phpMyAdmin. i developed a form . From wher user can insert the Car plate No. to the MySQL database.Both of the php file for inserting and veiwing is encoded in UTF-8 format. suppose i want to insert plate no as . 1 2 3 ص ص ص ص but i after inserting to the database i see the plate no as 1 2 3 ق ق ق ق in the database . In Database the plateno field's collation is...
8
8883
by: Jonathan Sachs | last post by:
I just tried to install phpMyAdmin on my system, and I can't get it to work. When I tried to run the setup procedure (setup.php) I got the following message: Fatal error: session_start() : Failed to initialize storage module: user (path: C:\...\Temp\php\session) in D\...\phpMyAdmin\libraries\session.inc.php on line 86 I set up the config file by hand, then tried to run phpMyAdmin and got the same error.
2
1911
by: seanh | last post by:
Hi all, I need some advice regarding phpmyadmin, I installed phpmyadmin directory in the htdocs but when I go to my http://mysite.com/phpmyadmin I get a 500 internal error. I checked the files from phpMyAdmin-3.1.3.2-english that I unziped on my desktop and compared each one to the ftp phpmyadmin directory files on the server so all files are all there. I also added config.inc.php file and put it inside phpmyadmin directory. I was wondering...
0
8590
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look ! Part I. Meaning of...
0
9072
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8947
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8782
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7621
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6453
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4321
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2964
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2215
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.