LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-11-2005, 01:12 PM   #1
jjdoll42
LQ Newbie
 
Registered: Apr 2005
Location: Texas
Posts: 11

Rep: Reputation: 0
Fedora Spanish Characters - a new twist: mySQL


Here is my problem. An FC3 server will not display spanish characters (ÁÉéáñ...) correctly that are (1) in static html pages or (2) in dynamic pages with those characters in the mySQL data.

GOOD NEWS
The fix on the static pages (1) is to modify the php.ini file and uncomment the line

;default_charset = "iso-8859-1"

so that is says

==> default_charset = "iso-8859-1"

BAD NEWS
The dynamic pages (2) still display Spanish characters incorrectly. I tried resolving this in the httpd.conf file, but was unsuccessful. By the way, the httpd.conf file on a diiferent server (RH9) that can correctly display spanish characters is not different on lines that have ISO-8859 or UTF-8 on them.

So, does anyone know how to make my FC3 server display mySQL data that has spanish characters in it?

I do not want to go through and manually change all of these to &138; &5 or other characters... too long, hard, and the other server I have (RH9) works fine...

So what is the fix?

Thanks.
 
Old 05-19-2005, 02:28 PM   #2
Gerakus
LQ Newbie
 
Registered: May 2005
Location: Mexico
Distribution: FC3
Posts: 1

Rep: Reputation: 0
This should fix the php dynamic pages, after you restart web apache server, so php.ini changes takes effect.

; PHP's built-in default is text/html
default_mimetype = "text/html"
default_charset = "iso-8859-1"

But only this would works if the httpd.conf file is also set up to use latin charset.

Code:
# Brazilian Portuguese (pt-BR) - Russian (ru) - Swedish (sv)
# Simplified Chinese (zh-CN) - Spanish (es) - Traditional Chinese (zh-TW)
find AddLanguage and you would see a list of AddLanguage directives, add this if is not list:
AddLanguage es .es

find LanguagePriority directive, and edit to look this way, if you check i put the Spanish as first on priority.
LanguagePriority es en ...

find AddDefaultCharset, and edit to look this way
AddDefaultCharset ISO-8859-1

find AddCharset, and add if doesnt exist this line:
AddCharset ISO-8859-1 .iso8859-1 .latin1

Atte. Angel.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
printing Spanish accent characters in Perl/tk entry widget puedo Programming 1 02-19-2005 01:16 PM
Fedora Core 3, MySql Server, mysql started mysql ended OkiTek Fedora 30 01-28-2005 09:15 AM
MySQL 4 on Fedora can't install php-mysql kennyg Linux - Software 8 09-21-2004 06:54 PM
Foreign Characters in Fedora RC2 bluemak Linux - Newbie 1 08-30-2004 08:37 AM
Print Spanish Characters in Epson FX-850 blas Linux - General 0 01-29-2004 12:56 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:29 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration