Missing characters in MySQL

[Andrew Mason]

On Wednesday 22 December 2004 12:42 pm, Niels Riis Kristensen wrote:
Did you check the apache config to see what character set its using...or what 
character sets are available

> Hi
>
> Nah, that is not so. And this is why:
>
> I have two identical databases on a Mac OSC server and a YDL 4.0
> server. All the characters are there in both databases.
>
> Search from Mac to Mac: All the characters shows.
> Search from Mac to Linux: No special characters shows.
> Search from Linux to Linux: No special characters shows.
> Search from Linux to Mac: No special characters shows.
>
> So you see, it is all the Linux configurations that are faulty and
> since the Mac can display characters from Mac but can't display
> characters from Linux, then wrong regionalization is not the problem.
>
> Furthermore I have made a clean english install with time zone set to
> mine (copenhagen) AND a clean danish install with full danish
> localization, and none displayed the characters.
>
> Niels Riis Kristensen
> (nrk at nrk-gruppen.dk)
>
> NRK Group
> - Electronic Music Engraving
> - Webhosting
> - Dynamic Web design
> - E-Lists hosting
>
> ---
> Send money safely over the Internet!
> Click this link for more information:
> https://www.paypal.com/refer/pal=EAJLSE5TQELFC
>
> On 22/12-2004, at 13.36, Andrew Mason wrote:
> > This isn't a MySQL/PHP issue..this just your browser not being set up
> > correctly for your region :)
> >
> > On Wednesday 22 December 2004 12:19 pm, Niels Riis Kristensen wrote:
> >> Hi
> >>
> >> A have a friend that finally convinced me to switch server platform
> >> from Mac OSX to YDL. But I have a major problem with MySQL (or PHP)
> >> that, if not fixed, will make me switch back as soon as I can finish
> >> the OSX install!
> >>
> >> I live in Denmark, Europe and in my country we have a few special
> >> characters that are special to our language. These characters are off
> >> course richly represented in my databases, some of which are pretty
> >> large (over 10.000 entries). My problem is, that these characters do
> >> not display when I make a php request from the websites. When I check
> >> the fields in PhpMyAdmin or Webmin the characters are there alright
> >> and
> >> the internal character set is the same as my Mac OSX server
> >> (ISO-8859-1). What is really worrying my, is that if I make let's say
> >> a
> >> search from YDL's mozilla browser to my Mac OSX server the characters
> >> doesn't show! Off course they show in my duplicate Mac search on the
> >> same database on the same machine.
> >>
> >> This is a major hurdle for me and if I can't get this to work this
> >> would be my shortest participation in a mail list ever!
> >>
> >> Can anyone please help me?
> >>
> >>
> >> Niels Riis Kristensen
> >> (nrk at nrk-gruppen.dk)
> >>
> >> NRK Group
> >> - Electronic Music Engraving
> >> - Webhosting
> >> - Dynamic Web design
> >> - E-Lists hosting
> >>
> >> ---
> >> Send money safely over the Internet!
> >> Click this link for more information:
> >> https://www.paypal.com/refer/pal=EAJLSE5TQELFC
> >>
> >> _______________________________________________
> >> yellowdog-newbie mailing list
> >> yellowdog-newbie at lists.terrasoftsolutions.com
> >> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-newbie
> >
> > _______________________________________________
> > yellowdog-newbie mailing list
> > yellowdog-newbie at lists.terrasoftsolutions.com
> > http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-newbie
>
> _______________________________________________
> yellowdog-newbie mailing list
> yellowdog-newbie at lists.terrasoftsolutions.com
> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-newbie