473,897 Members | 3,030 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Russian characters in MySQL and phpMyAdmin

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 like this in the phpMyAdmin). If I try to show the data
saved in the DB - which can be perfectly seen in the correct form in
the phpMyAdmin - I get only question marks instead of the characters
(the same quantity however) displayed on my site.

Why does it all work in the phpMyAdmin and does not in my project?

I checked the source code of the phpMyAdmin and found the line
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
which I have either in my site. Nevertheless, it does not help much...

What else could be the reason?

Regards
Victor

Sep 28 '06 #1
2 6811
Victor wrote:
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 like this in the phpMyAdmin). If I try to show the data
saved in the DB - which can be perfectly seen in the correct form in
the phpMyAdmin - I get only question marks instead of the characters
(the same quantity however) displayed on my site.

Why does it all work in the phpMyAdmin and does not in my project?

I checked the source code of the phpMyAdmin and found the line
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
which I have either in my site. Nevertheless, it does not help much...

What else could be the reason?

Regards
Victor
Read the following tutorial and I do believe your problem will be solved:
http://www.adviesenzo.nl/examples/ph...l_charset_fix/
Sep 29 '06 #2
Thanks Juliette!

Sep 29 '06 #3

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

Similar topics

0
1902
by: phpnube | last post by:
I used this php package to install on my system... (i had problems with the isapi package from php so im back to the cgi portion of PHP php-cgi.exe) PHP 5.0.0 installer - 26 July 2004 (CGI only, packaged as Windows installer to install and configure PHP, and automatically configure IIS, PWS and Xitami, with manual configuration for other servers. N.B. no external extensions included It works fine... as the test page outputs the...
2
2130
by: Charles Alexander | last post by:
This is a really, really elementary (almost dumb) question. I have a php script I picked up elsewhere that I want to use to query my MySQL DB. I have phpMyAdmin. I'd like to somehow run this script via phpMyAdmin so I can bookmark this for future reference. How do I do it? The phpMyadmin interface doesn't like the variable declarations like $query1="SELECT blah, blah"; when I do it manually.
2
2892
by: Ross Noe via .NET 247 | last post by:
(Type your message here) -------------------------------- From: Ross Noe I created an XML file using ASP that has Russian characters. Forsome reason ASP.Net doesn't read the Russian charactersproperly. Is .net capable of reading Russian characters from anXML file created with ASP? The application that the users use toupdate the XML file is still written in ASP and not in ASP.Net.Thanks in advance. ----------------------- Posted by a...
0
3489
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...
6
4376
by: Victor | last post by:
Hi everybody, could anybody help me with the following problem : I need to set a cookie containing a Russian character string as the value, using the construct "document.cookie = ...". The whole project runs in the UTF-8 encoding. The Internet Explorer handles this cookie correctly, whereas the FireFox writes only some byte gargabe and then reads it back.
2
2788
by: Victor | last post by:
Hi everybody, could anybody kindly give me a hint for dealing with the following problem : I need to send e-mails from a PHP 5 script running on Windows Apache, containing Russian characters in the subject and in the content. I use the function mail($to,$subject,$content,$header). The header looks like this now : "From: xyz@abcdef.com\r\nX-Mailer: PHP/".phpversion()."\r\nContent-Type: text/plain; charset='utf-8'"
2
1859
by: Sushmita | last post by:
Hi All I am trying to read russian characters from xml,while doing so,i have taken care of UTF-8,but still few letters come in form of question marks and square blocks. Please can anyone help me out with this.... Thanks..
7
6810
by: Sushmita | last post by:
Hi All I am trying to read russian characters from xml,while doing so,i have taken care of UTF-8,but still few letters come in form of question marks and square blocks. Please can anyone help me out with this.... Thanks..
1
3536
by: kersti | last post by:
We've just started to work on a Russian website. In the near future we expect to be running with a Japanese one as well. Currently our setup doesn't allow Russian characters - we need to do any Russian characters using unicode. What do I need to do to allow my developers to drop in Russian text without upsetting the 25 English websites that we're running?
0
9990
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, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11250
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...
1
10941
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
10478
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9656
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 project—planning, coding, testing, and deployment—without 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
8032
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
5873
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
4698
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
3
3300
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.