Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 05-11-2005, 02:12 PM   #1
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.

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"

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?

Old 05-19-2005, 03:28 PM   #2
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.

# 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.


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 02:16 PM
Fedora Core 3, MySql Server, mysql started mysql ended OkiTek Fedora 30 01-28-2005 10:15 AM
MySQL 4 on Fedora can't install php-mysql kennyg Linux - Software 8 09-21-2004 07:54 PM
Foreign Characters in Fedora RC2 bluemak Linux - Newbie 1 08-30-2004 09:37 AM
Print Spanish Characters in Epson FX-850 blas Linux - General 0 01-29-2004 01:56 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:05 AM.

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