Missing characters in MySQL

Andrew Mason andrew at assertis.net
Wed Dec 22 06:15:15 MST 2004


On Wednesday 22 December 2004 1:04 pm, Niels Riis Kristensen wrote:
> If i make a php request mb_internal_encoding() it returns ISO-8859-1,
> and in my Mac httpd.conf all the languages needed are listed. I have to
> wait with the Linux configuration since I am trying yet another install
> combination of YDL. Will be back with the httpd.conf values then.
ok. I'd say that the most likely problem is just that apache is configured 
without the extra languages. 
>
>
>
> 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.55, Andrew Mason wrote:
> > 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
> >
> > _______________________________________________
> > 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


More information about the yellowdog-newbie mailing list