473,809 Members | 2,733 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

charset illusion

I work with MySQL/PHP/Apache many years.

I am Greek so, in many pages, I use Greek language.

the problem is this:
I have 2 group of programs with different interaction:

group 1: PHP, MySQL Command Center
group 2: MySQL Query Browser, MySQL Administrator

and I have 2 CREATE TABLE

for 1st CREATE TABLE (greek), group 2 works fine and group 1 display
greek characters like this "?"

for 2st CREATE TABLE (latin1), group 1 works fine and group 2 display
greek characters like this "|"

Until now, I worked with MySQL Command Center but now project is stopped.

So, I must fix this problem.
What's wrong?

----------1----------
CREATE TABLE `anniversaries` (
...........
`event` text NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=greek
----------2----------
CREATE TABLE `anniversaries` (
...........
`event` text NOT NULL,
) ENGINE=MyISAM DEFAULT CHARSET=latin1
---------------------
Jul 23 '05 #1
0 1127

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

Similar topics

4
6200
by: CJ Oxx | last post by:
I have a problem with browser charset recognition when using PHP 4.1.2 (this is the PHP version which our hosting company provides). For charset recognition, I use the following meta-tag: <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> Here is what I have tried so far: - Regular html page: charset is properly recognised - PHP page which just prints out the html: charset is not properly recognised (ISO charset is...
12
3750
by: lawrence | last post by:
How do I get PHP to tell the server that when I echo text to the screen, I need for the text to be sent as UTF-8? How does Apache know the right encoding when all the text is being generated by PHP? If I build a content management system (I have) and I make sure that all input is encoded as UTF-8, how will the server know that the text in the MySql database is UTF-8? I'm taking all user input and using this function on the input: ...
8
3689
by: Ben Sharvy | last post by:
I don't reallly understand charsets, but I see that you are supposed to declare one. I am putting a paper up in HTML. It uses some special characters, like umlauts and diacriticals. The biggest problem I've had with it is creating characters with lines over them (macrons), as is done to indicate a long vowel sound, for example. There is no way to do this using my word processor. Is there a way to do it in an HTML document? Which charset...
25
3021
by: Andrew Thompson | last post by:
I was recently loading an HTML editor so I could find the charcode of that particularly obscure character using the editor's 'insert special character' dialog. It occured to me there had to be a better way. There are probably dozens, but here is my solution.. http://www.physci.org/codes/charset.jsp
3
2651
by: Jonathan Mcdougall | last post by:
I started using boost's filesystem library a couple of days ago. In its FAQ, it states "Wide-character names would provide an illusion of portability where portability does not in fact exist. Behavior would be completely different on operating systems (Windows, for example) that support wide-character names, than on systems which don't (POSIX). Providing functionality that appears to provide portability but in fact
19
20412
by: Onideus Mad Hatter | last post by:
http://www.backwater-productions.net/_test_platform/cbstory/ Works perfect in IE but in Netscape/Firefox it fuxors. The problem is the transparent image overlays. The obvious approach would be to split apart the overlaid images into 4 sections and just leave the text area uncovered...however that would require at least a good 3 to 4 hours of work and...well I'd rather just set the text box on top, loose the aesthetics and say to hell...
4
2447
by: Failure | last post by:
As far as I know, Groupboxes only come in one shape, a rectangle. But on one of my forms, it would be best if I could have a groupbox that's shaped like this: _______ | | _________| | | | | | |_______________|
7
5982
by: gmclee | last post by:
Hi there, I am writing a program to load HTML from file and send it to IE directly. I've met some problem in charset setting. Most of HTML have charset "us-ascii", for some reason, some UNICODE TEXT will be inserted into the HTML before sending to IE. The problem is 1) Can I specify special charset for some component, e.g. <span charset="UTF-8"SOME UNICODE HERE</spand> 2) If "NO" for 1), so any way to change the charset of the...
0
978
by: turku900 | last post by:
http://www.optical-illusion.org/?ma Here's a collection of nearly 600 pictures collected from the Internet over the years. Many of these pictures are new, many are old. They're all intended to mess with your head. (Careful, we didn't check them all for 18+)
0
9721
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
9601
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10637
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
10376
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
10379
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
10115
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
6881
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5550
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...
2
3861
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.