I have just started using mySQL and learning how to use it, so please
accept my apologies in advance if this has already been asked here. There
is an option to download all archives, but no search facility.
I am from Brazil, and one should note that Portuguese makes extensive use
of diacritics, ie, accented vowels and the cedilla. In Brazil, most people
use a Brazilian ABNT 2 layout keyboard, like the one I have. Learning
mySQL, I started doing a lot of tests in the DOS command line. I wanted to
use the up arrow key to call the history of recent commands and save some
typing, so I started running mysqlc.exe instead of mysql.exe. I soon
discovered that the environment created by mysqlc.exe won't let me type in
any diacritics. The accented vowels are input but without the accents, and
the cedillas are simply not input at all. I can type in diacritics in any
other situation whatsoever where I have to use DOS, including when I run
mysql.exe. Only mysqlc.exe is causing me that problem.
I thought it could be a bug and sent a message to the support at MySQL AB,
and someone replied telling me that it's not a bug, and that I had to fix
my autoexec.bat and config.sys (but didn't say HOW). That got me even more
confused, because I never had any problems typing diacritics in DOS. I only
had problems with mysqlc.exe. Running mysql.exe instead of mysqlc.exe, I
can input the diacritics without any problems.
Now that I started using mySQL with PHP, I ran into another problem. I
cannot retrieve data containing diacritics from a database to a Web page
through a PHP script. Accented vowels become a blank space, and cedillas
become a funny symbol that resembles a cross ( ‡ ).
Is there some way I can fix it and use mySQL in my local system, with all
diacritics? I've scoured the Web after an answer to my problem, especially
Brazilian forums, hoping that someone else might have just that same
problem and found a solution, but haven't found anything so far. I am
running Windows 95, PHP 4.1.0, Xitami and mySQL 3.23.47. I did not compile
mySQL, I just downloaded the Windows binary installation from
www.mysql.com.
Thank you very much,
Luciano Espirito Santo
Santos - SP - Brasil
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
